Read From Snowflake¶
This node reads a table from Snowflake
Output¶
Dataframe created from the data read from Snowflake
Type¶
dataset
Class¶
fire.nodes.snowflake.NodeReadFromSnowFlake
Fields¶
Name |
Title |
Description |
|---|---|---|
authType |
Auth Type |
Authentication Type. Possible value is OAUTH or USER_CREDENTIAL or KEYPAIR |
connection |
Connection |
The Snowflake connection to connect |
sfWarehouse |
Snowflake Warehouse |
Warehouse for connecting to the Snowflake |
sfDatabase |
Snowflake Database |
Database for connecting to the Snowflake |
sfSchema |
Snowflake Schema |
Schema for connecting to the Snowflake |
dbtable |
Snowflake Table/View |
Snowflake Table/View from which to read the data |
schema |
InferSchema |
|
outputColNames |
Output Column Names |
Name of the Output Columns |
outputColTypes |
Output Column Types |
Data Type of the Output Columns |
outputColFormats |
Output Column Formats |
Format of the Output Columns |
properties |
Properties |
|
extraOptionsKeys |
Properties Name |
Extra options/properites available while executing in Read Snowflake. |
extraOptionsValues |
Properties Value |
Config Values for the Corresponding properites name |
Details¶
Read from Snowflake Node Details¶
This node reads a table from Snowflake and creates the DataFrame which contains the schema and data of the specified table.
Parameters to be set:¶
OUTPUT STORAGE LEVEL : Keep this as DEFAULT.
CONNECTION : Select the desired snowflake connection to be used.
SNOWFLAKE WAREHOUSE : Specify the virtual warehouse to use for the connection.
SNOWFLAKE DATABASE : Specify the database to use once connected.
SNOWFLAKE SCHEMA : Specify the schema to use for the specified database once connected.
Snowflake TABLE/VIEW : Specify the table/view from which data is to be read.