DataResearchLabs / sql_scriptsLinks
Useful sql scripts and snippets for MSSQL, Oracle, PostgreSQL, Greenplum, and MySQL
☆97Updated 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 5 months ago
- The Virtual Data Warehouse is a code generation and template management tool. It is part of the data solution automation ecosystem - the …☆46Updated 4 months ago
- Various example reports I use for Microsoft Report Server (SSRS & PBIRS) as well as documents for unit testing, requirements and a style…☆150Updated last month
- Generic interface exchange format for Data Warehouse Automation and ETL generation.☆42Updated last year
- Microsoft Integration Services (SSIS) Source component☆48Updated 4 years ago
- Database Project with generic procedures to consume API through GET/POST methods.☆144Updated 4 years ago
- dbt-utils for the dbt-msft family of packages☆33Updated last year
- The Taxonomy for ETL Automation Metadata (TEAM) is a tool for design metadata management geared towards data warehouse automation. It is …☆37Updated 10 months ago
- SSASQueryAnalyzer is a tool to analyze and troubleshoot MDX queries on Analysis Services Multidimensional☆23Updated 7 years ago
- ☆29Updated 3 years ago
- Optimal Data Engine (ODE) for MSSQL☆14Updated 6 years ago
- Transact-SQL scripts and gists☆58Updated 2 months ago
- Various scripts I use for SQL Server databases. These include Reporting Services, Primavera P6, and general administration T-SQL backup …☆100Updated 2 years ago
- a set of scripts to pull meta data and data profiling metrics from relational database systems☆77Updated last year
- ☆195Updated 8 months ago
- An Azure Function which allows Azure Data Factory (ADF) to connect to Snowflake in a flexible way.☆26Updated 2 years ago
- Asynchronous T-SQL procedure execution☆24Updated 12 years ago
- SCD Merge Wizard is an application which will help you generate T-SQL statement for merging data from two tables into one table in minute…☆44Updated last year
- DIRECT, the Data Integration Run-time Execution Control Tool, is a data logistics control framework that can be used to monitor, log, aud…☆28Updated 2 weeks ago
- Execution of DBT models using Apache Airflow through Docker Compose☆125Updated 2 years ago
- SQL Server Metadata Toolkit☆85Updated 11 months ago
- An example dbt project using AutomateDV to create a Data Vault 2.0 Data Warehouse based on the Snowflake TPC-H dataset.☆55Updated last year
- SQL Server docker image with all sample databases☆41Updated last year
- dbt tutorial using a local PostgreSQL database☆40Updated 3 years ago
- This is an Excel Addin for Windows that reads and writes data to Snowflake☆90Updated 2 years ago
- A box of tricks (SQL scripts) that I've built up over many years for Microsoft SQL Server instance and database administration, and gener…☆287Updated last year
- Azure Data Factory Cookbook, published by Packt☆37Updated 2 years ago
- Visio stencils and artefacts related to data vault guru☆50Updated 3 years ago
- Docker Learning Examples☆57Updated 5 months ago