| name |
string |
Name of the pipe |
| comment |
string |
user comment associated to an object in the dictionary |
| auto_ingest |
boolean |
TRUE if all files from stage need to be auto-ingested |
| error_integration |
string |
Link to integration object that point to a user provided Azure storage queue / SQS. When present, errors (e.g. ingest failure for Snowpipe or a user task failure or replication failure) will be sent t |
| aws_sns_topic |
string |
Optional, if provided, auto_ingest pipe will only receive messages from this SNS topic. |
| integration |
string |
Link to integration object that ties a user provided storage queue to an auto_ingest enabled pipe. Required for auto_ingest to work on azure. |
| copy_statement |
string |
COPY INTO statement used to load data from queued files into a Snowflake table. This statement serves as the text/definition for the pipe and is displayed in the SHOW PIPES output
| created_on |
string |
Date and time when the pipe was created. |
| database_name |
string |
Database in which the pipe is stored |
| schema_name |
string |
Schema in which the pipe is stored |
| owner |
string |
Role that owns the pipe |
| pattern |
string |
PATTERN copy option value in the COPY INTO statement in the pipe definition, if the copy option was specified.
| owner_role_type |
string |
The type of role that owns the pipe |
| invalid_reason |
string |
Displays some detailed information for your pipes that may have issues |
| budget |
string |
Name of the budget if the pipe is monitored by a budget |
| |