Data Warehouse Analyst – Analytics Engineer @ OTUS.ru
0. Fork demo repo: https://github.com/kzzzr/dbtvault_greenplum_demo
Follow instructions in data_vault_tutorial.md step by step.
Add README.md with answers to the following questions:
mr_zidcov Zidcov
Zidcov
/ CalendarGenerator.m
Created
June 13, 2022 20:13
— forked from aaronsteers/CalendarGenerator.m
Power BI Calendar Function
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # Step 1: Create a CalendarGenerator() function and paste the contents below into the Advanced Editor | |
| let CreateDateTable = (StartDate as date, EndDate as date, optional Culture as nullable text) as table => | |
| let | |
| DayCount = Duration.Days(Duration.From(EndDate - StartDate)), | |
| Source = List.Dates(StartDate,DayCount,#duration(1,0,0,0)), | |
| TableFromList = Table.FromList(Source, Splitter.SplitByNothing()), | |
| ChangedType = Table.TransformColumnTypes(TableFromList,{{"Column1", type date}}), | |
| RenamedColumns = Table.RenameColumns(ChangedType,{{"Column1", "Date"}}), | |
| InsertYear = Table.AddColumn(RenamedColumns, "Year", each Date.Year([Date])), | |
| InsertQuarter = Table.AddColumn(InsertYear, "Quarter Number", each Date.QuarterOfYear([Date])), |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # install dbt: https://docs.getdbt.com/dbt-cli/installation | |
| pip install dbt==0.19.0 | |
| # clone repo | |
| git clone https://github.com/dbt-labs/jaffle_shop | |
| # create ~/.dbt/profiles.yml | |
| # ensure profile setup | |
| dbt debug |
Zidcov
/ assignment.md
Created
April 8, 2022 18:36
— forked from kzzzr/assignment.md
Data Vault 2.0 + Greenplum + dbtVault assignment
Zidcov
/ _assignment.md
Created
April 1, 2022 20:04
— forked from kzzzr/_assignment.md
Analytics Engineer – dbt + Clickhouse Assignment
yc managed-clickhouse cluster help
Zidcov
/ gist:2608f5abc43e0ace8550f36b8a11bb36
Created
April 26, 2020 18:21
— forked from simplesasha/gist:73005e8e08065d8c360dba09dc86626b
Интеграция Python 3 в Sublime Text 3 (простая и интерактивная консоль REPL)
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 1. Открываем Sublime Text -> Tools -> Build System -> New Build System | |
| 2. Вставляем в открывшийся файл следующие строки, чтобы получилось вот так: | |
| { | |
| "cmd": ["python3", "-i", "-u", "$file"], | |
| "file_regex": "^[ ]File \"(...?)\", line ([0-9]*)", | |
| "selector": "source.python" | |
| } | |
| 3. Сохраняем файл с названием python3.sublime-build и не меняем путь предложенный редактором |
Zidcov
/ suggest-google-sheets.js
Created
November 7, 2019 21:04
— forked from nalgeon/README.md
Пример работы с подсказками DaData в Google Taблицах
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // Замените на свой API-ключ из личного кабинета (https://dadata.ru/profile/#info) | |
| var API_KEY = "ВАШ_API_КЛЮЧ"; | |
| /*** | |
| /* Не меняйте код ниже этой строчки | |
| ***/ | |
| var FORMATTERS = { | |
| address: formatAddress, | |
| fio: formatFio, |
Zidcov
/ PrettySourcesDateTableRu.m
Created
October 28, 2018 14:28
— forked from DmitriyVlasov/PrettySourcesDateTableRu.m
функция в Power Query (язык M) создает таблицу с датами. Дополняет ее различными столбцами, включая данные о государственных выходных дня в РФ.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // killerDateTableRu | |
| // функция killerDateTableRu создает таблицу с датами. Дополняет ее различными полезными для Time Intelligence столбцами. | |
| // В случае, если четвертый аргумент принимает Дни 1, то функция добавляет столбец с выходными. | |
| // Оригинальная идея philbritton https://gist.github.com/philbritton/9677152 | |
| // пример: killerDateTableRu(#date(2017, 2, 1), #date(2017, 2, 4), "RU-ru", 1) | |
| // Описание полей результирующей таблицы: | |
| // =================================================== | |
| // Date - дата | |
| // Year - год |