Basic Use Case (Azure SQL - Table List)

This example demonstrates how the Azure SQL - Table List Snap retrieves all tables from the dbo schema in an Azure SQL Database and outputs their metadata, including dependency order when the Compute table graph option is enabled.



Download this Pipeline
  1. Configure the Azure SQL - Table List Snap with Schema Name set to dbo and enable Compute table graph.
  2. Execute the pipeline as a standalone Snap. The Snap outputs one document per table found in the schema.


  3. Review the output: tables are listed in topological order (least dependent first). Each document includes the table name and a dependents array showing foreign key relationships to other tables.
  4. Optionally, add a Filter Snap downstream to select only tables with a specific dependency. For example, to find all tables dependent on table A, use the expression: $.dependents.indexOf('A') != -1
To reuse the example pipelines:
  1. Download and import the SLP file into your Environment.
  2. Configure Snap accounts.
  3. Provide Pipeline parameters, if any.