Skip to main content

Snowflake_Connection.read

readquerylimit

Group: Input
Aliases: import, load, open, query, sql

Documentation​

Execute the query and load the results into memory as a Table.

Arguments​

  • query: name of the table or sql statement to query. If supplied as Text it is treated as a table name.
  • limit: the maximum number of rows to read.

Remarks​

Side Effects​

Note that the read method is running without restrictions when the output context is disabled, but it can technically cause side effects, if it is provided with a DML query. Usually it is preferred to use execute_update for DML queries, or if they are supposed to return results, the read should be wrapped in an execution context check.