Connect to a Snowflake Table
This section explains how to connect to a table in Snowflake. Before creating a Function, ensure you have already created the corresponding System within a System Line.
Technical Parameters
To connect to a table in Snowflake select the Technical Handler 'Snowflake_Query'. For the Technical Parameters, please specify the following options. The options in BOLD are REQUIRED:
COLUMN_SELECTION: '*', in case you want to select all columns. To select specific columns, separate them by semicolon.
-
SCHEMA: The name of the schema the table or view is located in.
-
TABLE: The name of the table to query.