sql
Last updated
Last updated
Prism users can execute sql queries using the hooks.sql()
function. This function takes three arguments:
adapter_name
: the adapter with which to run the SQL query. This should match the adapter name in profile.yml
.
query
: the SQL query as a string
return_type
: the return type for the SQL query. The default value is "pandas"
for returning a Pandas DataFrame. Other valid options include:
None
if you want to create a table, view, schema, database, etc.
The configurations for these adapters need to be specified in , and they are covered in more detail next.