Skip to main content

Alpha version of rasgoQL open-source package.

Project description

RasgoQL

RasgoQL is a light-weight data transformation package to bridge the gap between dbt and pandas. It allow users to construct, print & run SQL queries using a familiar python syntax. Under the covers it sends all processing to your data warehouse, allowing efficient transformation of massive datasets.

RasgoQL does these things well:

  • Pulls existing DataWarehouse tables into pandas DataFrames for analysis
  • Constructs SQL queries using a syntax that feels like pandas
  • Creates views in your DataWarehouse to save transformed data
  • Exports runnable sql in .sql files or dbt-compliant yml files
  • Offers dozens of free SQL transforms to use
  • Coming Soon: allows users to create & add custom transforms

Documentation is available at: https://docs.rasgoql.com

Ways RasgoQL can help

  • If you use pandas to build features, but you are working on a massive set of data that won't fit in your machine's memory. RasgoQL can help!

  • If your organization uses dbt of another SQL tool to run production data flows, but you prefer to build features in pandas. RasgoQL can help!

  • If you know pandas, but not SQL and want to learn how queries will translate. RasgoQL can help!

Package Dependencies


  • jinja2
  • pandas
  • pyyaml
  • python-dotenv
  • rasgotransforms

[snowflake]

  • snowflake-connector-python
  • snowflake-connector-python[pandas]

[bigquery]

  • google-auth-oauthlib
  • google-cloud-bigquery

[postgres]

  • psycopg2
  • SQLAlchemy
  • psycopg2-binary # Linux

[redshift]

  • redshift_connector
  • SQLAlchemy
  • sqlalchemy-redshift

Major Version Releases


  • v1.0.0 (Feb 23, 2022)

    • Added support for BigQuery
    • Added support for Snowflake
    • Added import dataset from pandas workflow
    • Added export to dbt workflow
  • v1.1.0 (Mar 8, 2022)

    • Added support for Postgres
  • v1.2.0 (Mar 24, 2022)

    • Added a parameter to allow batch returning of Pandas DataFrames from to_df() and query_into_df() methods
  • v1.3.0 (Mar 25, 2022)

    • Added support for MySQL
  • v1.4.0 (April 8, 2022)

    • Added failure and execution telemetry for methods in Transform and Dataset classes
  • v1.5.0 (April 9, 2022)

    • Added support for Amazon Redshift

See Changelog for full minor version release notes

About Us

RasgoQL is maintained by Rasgo. Rasgo's enterprise feature store integrates with your data warehouse to help users build features faster, collaborate with team members, and serve features to models in production.

Built for Data Scientists, by Data Scientists

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

rasgoql-1.6.4.tar.gz (32.8 kB view hashes)

Uploaded Source

Built Distribution

rasgoql-1.6.4-py3-none-any.whl (49.2 kB view hashes)

Uploaded Python 3

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page