Hex connects directly to Google BigQuery to let you query big data with familiar SQL syntax, without exporting csv files or needing a Python connector.
Connecting a Google BigQuery project to Hex means everyone can securely and efficiently query data right from the flexible notebook environment, without writing Python code or passing around credentials.
Hex features full SQL IDE functionality, with autocomplete, a schema browser, caching, and the ability to stream large results.
You can build and publish beautiful and interactive data apps entirely from SQL queries to your BigQuery data— or you can switch seamlessly into Python and build models, enrich data, or merge other data sources.
"Hex has the best parts of using a Jupyter notebook without the limitations. I hadn’t really experienced being able to slip really quickly between the logic and the application builder view before Hex."