Bots From Extension: snowflake
Snowflake - Inventory collection from Snowflake
This extension provides 9 bots.
Bot @snowflake:databases
Bot Position In Pipeline: Source
Snowflake - Get Databases.
This bot expects a Restricted CFXQL.
Each parameter may be specified using '=' operator and AND logical operation
Following are the parameters expected for this Bot
| Parameter Name | Type | Default Value | Description |
|---|---|---|---|
| account | Text | Snowflake account |
Bot @snowflake:native-query
Bot Position In Pipeline: Source Sink
Snowflake - Run native SQL query on the Database.
This bot expects a Restricted CFXQL.
Each parameter may be specified using '=' operator and AND logical operation
Following are the parameters expected for this Bot
| Parameter Name | Type | Default Value | Description |
|---|---|---|---|
| dbname* | Text | Snowflake database | |
| warehouse* | Text | Snowflake warehouse | |
| role | Text | Snowflake role | |
| schema | Text | Snowflake schema | |
| query* | Text | Enter native Snowflake SQL query. | |
| _skip_errors | Text | no | Specify 'yes' or 'no'. If 'yes', do not bailout if the query results in error. |
| retry_count | Text | 0 | Number of times to retry on failure. |
| retry_interval | Text | 10 | Seconds to wait before retrying on failure. |
Bot @snowflake:native-query-stream
Bot Position In Pipeline: Source
Snowflake - Stream SQL query data from the Database.
This bot expects a Restricted CFXQL.
Each parameter may be specified using '=' operator and AND logical operation
Following are the parameters expected for this Bot
| Parameter Name | Type | Default Value | Description |
|---|---|---|---|
| dbname* | Text | Snowflake database | |
| warehouse* | Text | Snowflake warehouse | |
| role | Text | Snowflake role | |
| schema | Text | Snowflake schema | |
| query* | Text | Enter native Snowflake SQL query. | |
| _skip_errors | Text | no | Specify 'yes' or 'no'. If 'yes', do not bailout if the query results in error. |
| retry_count | Text | 0 | Number of times to retry on failure. |
| retry_interval | Text | 10 | Seconds to wait before retrying on failure. |
| limit | Text | 1000 | To limit the number of rows from the query, set 0 to remove the limit. (Pass from input dataset) |
| bookmark | Text | Name of the bookmark |
Bot #snowflake:read
Bot Position In Pipeline: Sink
Snowflake - Query data from a Database Table. Expects 'warehouse', 'dbname', 'table' and 'schema' columns from input dataset; Optional 'limit' can also be provided (default 1000).
This bot expects Full CFXQL.
Bot translates the Query to native query of the Data source supported by this extension.
Bot @snowflake:read-stream
Bot Position In Pipeline: Source
Snowflake - Stream queried data from a Database Table.
This bot expects a Restricted CFXQL.
Each parameter may be specified using '=' operator and AND logical operation
Following are the parameters expected for this Bot
| Parameter Name | Type | Default Value | Description |
|---|---|---|---|
| warehouse* | Text | Snowflake warehouse | |
| dbname* | Text | Snowflake database | |
| table* | Text | Snowflake table | |
| schema* | Text | Snowflake schema | |
| role | Text | Snowflake role | |
| limit | Text | 1000 | To limit the number of rows from the query, set 0 to remove the limit. (Pass from input dataset) |
| retry_count | Text | 0 | Number of times to retry on failure. |
| retry_interval | Text | 10 | Seconds to wait before retrying on failure. |
| cfxql_query | Text | * | CFXQL query |
| bookmark | Text | Name of the bookmark |
Bot @snowflake:roles
Bot Position In Pipeline: Source
Snowflake - Get Roles.
This bot expects a Restricted CFXQL.
Each parameter may be specified using '=' operator and AND logical operation
Following are the parameters expected for this Bot
| Parameter Name | Type | Default Value | Description |
|---|---|---|---|
| account | Text | Snowflake account |
Bot @snowflake:schemas
Bot Position In Pipeline: Source
Snowflake - Get Database Schemas.
This bot expects a Restricted CFXQL.
Each parameter may be specified using '=' operator and AND logical operation
Following are the parameters expected for this Bot
| Parameter Name | Type | Default Value | Description |
|---|---|---|---|
| account | Text | Snowflake account |
Bot @snowflake:tables
Bot Position In Pipeline: Source
Snowflake - Get Database Tables.
This bot expects a Restricted CFXQL.
Each parameter may be specified using '=' operator and AND logical operation
Following are the parameters expected for this Bot
| Parameter Name | Type | Default Value | Description |
|---|---|---|---|
| account | Text | Snowflake account | |
| schema | Text | Snowflake schema | |
| concurrent_discovery | Text | 10 | Number of concurrent jobs to run |
Bot @snowflake:warehouses
Bot Position In Pipeline: Source
Snowflake - Get Warehouses.
This bot expects a Restricted CFXQL.
Each parameter may be specified using '=' operator and AND logical operation
Following are the parameters expected for this Bot
| Parameter Name | Type | Default Value | Description |
|---|---|---|---|
| account | Text | Snowflake account |