You can upload your SQL code in following ways:
- from your browser through the Dashboard
- use our app called Lionfish
- connect to our REST API directly
Each upload will appear in your Dashboard where you can view it or delete it.
#1 Uploading SQL code through the browser
Copy & Paste
- best way how to quickly try your SQL query
- do not use it for uploading multiple queries
Upload a ZIP file
- best for uploading multiple queries (no limit on the query count)
- each query has to be placed in separate file
- if you uploaded 100 queries and 1 fails to process the remaining 99 are still visualised (this method allows independent processing)
#2 Use our app called Lionfish
- highly recommended option when your code is stored directly in the database
- it connects to your database catalogue and extracts Views, Stored procedures, Database links, etc.
- you can modify SQL queries executed by Lionfish so it connects to your custom table (for example where you log your SQL queries)
- you can use database account with a minimal privileges so you are 100% sure that Lionfish cannot access your data
#3 REST API
Our service can be interacted with using REST API -- see full documentation
You can write your own program in Java, Python, etc. that will prepare SQL code from your storage and upload it directly to our API.
Through API you can also generate a public link which is valid for limited period of time. Useful if you decide to make your visualisations public.
Uploaded batch & SQL parser performance
Your uploaded batch is placed into a queue and then our SQL parser runs the analysis. Generally speaking:
- the queue shouldn't be longer then 10 seconds
- it takes less then 1 second to parse a single SQL statement
Our focus is on data linage. Therefore any valid SQL query impacting the data lineage is supported. This includes procedural code, views, database links, etc. for more details go here.