To select all fields, leave it at default. Specify the number of rows to return from the query.Įnter or select output fields for Snowflake SQL SELECT statement. This is where the result set should start. The default database sort order will be used.
Specify the columns in the order in which you want to sort the database. This supports document value substitution (such as $person.firstname will be substituted with the value found in the incoming document at the path). Specify the where clause of the SELECT statement. Specify the table to execute the select query on. The property is suggestible and will retrieve available database schemas during suggest values. In case it is not defined, then the suggestion for the Table Name will retrieve all table names of all schemas. You can modify this to be more specific, especially if you have more than one of the same Snap in your Pipeline. This Snap has at most one error view and produces zero or more documents in the view. This Snap has one document output view by default.Ī second view can be added to show the metadata for the table as a Document. The metadata document can then be fed into the second input view of Snowflake - Insert or Bulk Load Snaps so that the table is created in Snowflake with a similar schema as the source table. This Snap has at most one document input view.
0 kommentar(er)
