You can upload your SQL code in following ways:

  1. from your browser through the Dashboard
  2. use our app called Lionfish
  3. 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

Supported syntax

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.

Did this answer your question?