SQL Cloud allows create and share CSV tables from SQL queries.
Download
Windows only: admin permission required
| View file | ||
|---|---|---|
|
Multi-platform (Windows,
...
macOS, Linux): Java installed is required.
| View file | ||
|---|---|---|
|
Step 1. Run the installer
c:\> java -jar install
...
Step 2. Run up the CSV Server
Type in your PC search bar “CSV”. In the appeared list of docs and applications click on the “SQL Cloud CSV Server” app.
This will start the SQL Cloud CSV Query Server locally:
Step 3. Copy the CSV URL
...
from SQL Cloud CSV Server console
Step 4. Open any browser and insert into the address bar the previously copied URL
“ http://localhost:4231/sqlc/csv?sql= “
Step 5. Insert your query into the previously copied URL.
You have two options how to do this:
You can write your query right in the address bar of your browser ( example: http://localhost:4231/sqlc/csv?sql=select * from PROJECT ). And press “Enter”.
You can go to your query console, write a query there or use SQLC Query Library to choose one, copy it from there, and insert it into the address bar.
1. Copy your query from the console (select all query +Ctrl+C /Comnd+C)
2. Enter copied query:
http://localhost:4231/sqlc/csv?sql=YOUR QUERY
And press Enter. It will automatically open a new page of SQLC Query Server and will ask you to enable the Server, and set a password (if you haven't done this before).
Step 6. Run a SQL query from your browser
Then you can crate CSV Tables with SQL from your browser.
Paste the URL above and replace the <query> parameter with yours
...
3. Enable your server and set a password. Go back to the browser and refresh page. It will send you back to the SQL Cloud Query Server page so you could see whether the Server is connected.
4. Go back to your browser and copy the entire URL.
Now This URL you can use to connect to a third-party tool that supports Data resources as URL.
Step 7. Share the query with third-parties
The URLs above displaying CSV on your browser can be safely shared as a data source with third-party tools like MS Power BI:
Open Power Bi. Select “Get Data”. Chose as a resource for your data “Web”
2. In opened dialog window insert the previously copied URL from your browser (look at Step 6. )
3. Press Ok and then Load.
Every time refreshing data it will execute the copied query in real-time.
Please pay attention that when you close the Server or CSV Cloud Console or stop Server - your data will not be refreshing anymore and you'll get this alert:
