View Source Snowflex (Snowflex v0.5.2)
The client interface for connecting to the Snowflake data warehouse.
The main entry point to this module is Snowflex.sql_query
. This function takes a string containing
a SQL query and returns a list of maps (one per row). NOTE: due to the way the Erlang ODBC works, all values comeback
as strings. You will need to cast values appropriately.
Link to this section Summary
Link to this section Types
Specs
odbc_data_type() :: :sql_integer | :sql_smallint | :sql_tinyint | {:sql_decimal, precision(), scale()} | {:sql_numeric, precision(), scale()} | {:sql_char, size()} | {:sql_wchar, size()} | {:sql_varchar, size()} | {:sql_wvarchar, size()} | {:sql_float, precision()} | {:sql_wlongvarchar, size()} | {:sql_float, precision()} | :sql_real | :sql_double | :sql_bit | atom()
Specs
precision() :: integer()
Specs
Specs
query_param() :: {odbc_data_type(), [value()]}
Specs
scale() :: integer()
Specs
size() :: integer()
Specs
Specs
value() :: nil | term()
Link to this section Functions
Specs
param_query(atom(), String.t(), [query_param()], query_opts()) :: sql_data() | {:error, term()} | {:updated, integer()}