get https://api.similarweb.com/v3/batch/snowflake/list-tables?integration_name=
This endpoint lists all the tables created under a certain Snowflake integration.
Response
The response contains a TablesList response, listing all tables accessible using the given integration. When no integration name is provided - the default integration name is "snowflake_default".
TablesList Object
This object contains all tables the user can access using the given integration.
| Property | Description | Example |
|---|---|---|
| tables List[IntegrationTable] | The tables created within the integration. | [ "site_visits" ] |
Note:
This endpoint is relevant only if the requesting user has a set tables in his Snowflake integration.
IntegrationTable Object
The object contains the information of a table defined within the given integration (usually these tables are created by the user himself).
| Property | Description | Example |
|---|---|---|
| columns Dict[str, List[str]] | The table's columns names. | { "names": [ "domain", "country", "date", "all_traffic_visits", "desktop_visits", "mobile_visits" ] } |
| granularity str | The granularity of the data in the table. Can be 'daily', 'weekly' or 'monthly'. | "daily" |
| metrics Optional List[str] | The metrics that their data is included in the table. | [ "all_traffic_visits", "desktop_visits", "mobile_visits" ] |
| snowflake_physical_name str | The full name of the table as appears on Snowflake. Combines the name of the table given by the user with it's account ID. | "my_snowflake_table_12345678" |
| table_name str | The name of the table. | "my_snowflake_table" |
| vtable Optional str | The name of the vtable from which the data is extracted. | "traffic_and_engagement" |