DataResearchLabs / sql_scriptsLinks
Useful sql scripts and snippets for MSSQL, Oracle, PostgreSQL, Greenplum, and MySQL
☆96Updated 3 years ago
Alternatives and similar repositories for sql_scripts
Users that are interested in sql_scripts are comparing it to the libraries listed below
Sorting:
- A framework for moving data into a data warehouse.☆57Updated 4 years ago
- A library for data warehouse and data integration pattern and architecture documentation.☆51Updated 4 months ago
- Set up the AdventureWorks sample database for use with Postgres☆452Updated last year
- Database Project with generic procedures to consume API through GET/POST methods.☆144Updated 4 years ago
- ETL process for creating a Data Warehouse using SQL Server (SSIS and SSMS). Project based on the AdventureWorks dataset.☆24Updated 7 years ago
- Docker Learning Examples☆56Updated 4 months ago
- Various scripts I use for SQL Server databases. These include Reporting Services, Primavera P6, and general administration T-SQL backup …☆99Updated 2 years ago
- Data Modeling with Snowflake, published by Packt☆68Updated 7 months ago
- a set of scripts to pull meta data and data profiling metrics from relational database systems☆77Updated last year
- The Virtual Data Warehouse is a code generation and template management tool. It is part of the data solution automation ecosystem - the …☆45Updated 4 months ago
- Adventureworks OLTP for training, tutorials☆65Updated last year
- Generic interface exchange format for Data Warehouse Automation and ETL generation.☆42Updated last year
- Execution of DBT models using Apache Airflow through Docker Compose☆124Updated 2 years ago
- An Azure Function which allows Azure Data Factory (ADF) to connect to Snowflake in a flexible way.☆26Updated 2 years ago
- ☆157Updated 4 months ago
- An implementation template for a Kimball (dimensional) Data Warehouse☆44Updated 7 years ago
- ☆196Updated 7 months ago
- Code for dbt tutorial☆165Updated 2 months ago
- Various example reports I use for Microsoft Report Server (SSRS & PBIRS) as well as documents for unit testing, requirements and a style…☆148Updated 2 weeks ago
- Building a Data Pipeline with an Open Source Stack☆54Updated 4 months ago
- Demonstrations of DBT☆16Updated 6 years ago
- Template for Data Engineering and Data Pipeline projects☆114Updated 2 years ago
- Repo contains the materializations for Data Engineers DataOps Framework☆34Updated 2 weeks ago
- DIRECT, the Data Integration Run-time Execution Control Tool, is a data logistics control framework that can be used to monitor, log, aud…☆28Updated last week
- End-to-end data platform leveraging the Modern data stack☆52Updated last year
- Pyspark Spotify ETL☆17Updated 4 years ago
- Data engineering with dbt, published by Packt☆87Updated 2 months ago
- This is project documentation templates derived from CRISP-DM to be used for Data Engineering projects.☆58Updated 4 years ago
- Python data repo, jupyter notebook, python scripts and data.☆539Updated 11 months ago
- A monorepo combining data modelling in dbt with data viz using Evidence☆22Updated 2 years ago