Build software better, together

getredash / redash

Make Your Company Data Driven. Connect to any data source, easily visualize, dashboard and share your data.

visualization javascript mysql python bigquery bi spark dashboard athena analytics postgresql business-intelligence redash redshift databricks hacktoberfest spark-sql

Updated Jul 9, 2022
Python

cube-js / cube.js

Star

Open

Time dimension on a runningTotal measure on Snowflake mixes quoted and unquoted columns

3

leogodin217 commented Sep 17, 2021

Describe the bug
Using a time dimension on a runningTotal measure on Snowflake mixes quoted and unquoted columns in the query. This fails the query, because Snowflake has specific rules about quoted columns. Specifically:

All unquoted column names are treated as upper case
Quoted column names are case sensitive.

So "date_from" <> date_from

To Reproduce
Steps to reproduce

"last n" timeDimension range short by 1 day for n > 1

2

Open

Deprecation warning from Serverless Variables Resolver when deploying to GCP using serverless template

2

Find more good first issues

awslabs / aws-data-wrangler

Star

Pandas on AWS - Easy integration with Athena, Glue, Redshift, Timestream, Neptune, OpenSearch, QuickSight, Chime, CloudWatchLogs, DynamoDB, EMR, SecretManager, PostgreSQL, MySQL, SQLServer and S3 (Parquet, CSV, JSON and EXCEL).

mysql python emr aws data-science lambda aws-lambda athena etl pandas data-engineering redshift apache-parquet amazon-athena apache-arrow aws-glue glue-catalog amazon-sagemaker-notebook

Updated Jul 8, 2022
Python

o2team / athena

Star

O2前端流程工具

nodejs athena build-tool

Updated Nov 8, 2018
JavaScript

laughingman7743 / PyAthena

Star

PyAthena is a Python DB API 2.0 (PEP 249) client for Amazon Athena.

python aws sqlalchemy athena dbapi

Updated Jul 5, 2022
Python

mlcraft-io / mlcraft

Star

Low-code metrics store, modern open-source alternative to Looker

mysql bigquery data-science machine-learning sql big-data spark presto hive athena analytics clickhouse postgresql datascience business-intelligence redshift

Updated Dec 26, 2021
JavaScript

aws-samples / aws-etl-orchestrator

Star

A serverless architecture for orchestrating ETL jobs in arbitrarily-complex workflows using AWS Step Functions and AWS Lambda.

aws lambda big-data serverless athena state-machine etl extract bigdata glue orchestration load transform amazon-web-services elt stepfunctions

Updated Feb 9, 2022
Python

justwatchcom / sql_exporter

Star

Flexible SQL Exporter for Prometheus.

mysql kubernetes sql athena clickhouse postgresql snowflake prometheus prometheus-exporter

Updated Jun 20, 2022
Go

wix / quix

Star

Quix Notebook Manager

bigquery presto athena notebook-manager

Updated Jul 8, 2022
TypeScript

fraugster / parquet-go

Star

Open

parquet-tool - file statistics command

1

panamafrancis commented Mar 4, 2022

As a user i would like a command to aid in debugging parquet files. For instance I would like to obtain the following file stats in a single command:

compression algorithm
page type v1/v2?
row group size
author / created by
version
metadata
page size
total records /row count
any internal info that could help too

parquet-tool - add version command

Open

Merge files function

1

dacort / metabase-athena-driver

Star

An Amazon Athena driver for Metabase 0.32 and later

aws athena metabase aws-athena amazon-athena athena-driver metabase-driver

Updated May 20, 2022
Clojure

HariSekhon / SQL-scripts

Star

100+ SQL Scripts - PostgreSQL, MySQL, Google BigQuery, MariaDB, AWS Athena. DevOps / DBA / Analytics / performance engineering. Google BigQuery ML machine learning classification.

Updated Jun 16, 2022
Shell

lynnlangit / Hello-AWS-Data-Services

Star

Sample code for AWS data service and ML courses on LinkedIn Learning

emr aws athena aws-sdk dynamodb kinesis aws-cli redshift rds sagemaker

Updated May 27, 2022
Jupyter Notebook

awslabs / athena-glue-service-logs

Star

Glue scripts for converting AWS Service Logs for use in Athena

athena elb-logs alb-logs cloudtrail-logs cloudfront-logs vpc-flow-logs aws-glue s3-log-parser glue-scripts glue-job

Updated Dec 28, 2021
Python

broccolini / athena

Star

A simple and elegant theme for Jekyll and GitHub Pages.

jekyll theme jekyll-site athena elegant-theme

Updated Feb 5, 2020
HTML

awslabs / voice-powered-analytics

Star

Workshop to build voice enabled integration with data analytics

alexa lambda workshop athena quicksight

Updated Mar 13, 2020
Python

KoteiIto / node-athena

Star

a nodejs simple aws athena client

nodejs javascript aws lambda typescript aws-lambda athena aws-athena athena-client

Updated May 12, 2021
TypeScript

uber / athenadriver

Star

A fully-featured AWS Athena database driver (+ athenareader https://github.com/uber/athenadriver/tree/master/athenareader)

go golang aws sql database uber athena sandbox driver s3 atg hiveql prestosql

Updated Feb 16, 2022
Go

laughingman7743 / PyAthenaJDBC

Star

PyAthenaJDBC is an Amazon Athena JDBC driver wrapper for the Python DB API 2.0 (PEP 249).

python aws sqlalchemy athena jdbc dbapi

Updated May 30, 2021
Python

athena-oss / athena

Star

An automation platform with a plugin architecture that allows you to easily create and share services.

bash docker automation athena plugin-architecture

Updated Jul 6, 2017
Shell

awsdocs / amazon-athena-user-guide

Star

The open source version of the Amazon Athena documentation. To submit feedback & requests for changes, submit issues in this repository, or make proposed changes & submit a pull request.

aws documentation athena