From 2aa4f9443e87abd804cde04200116225c2c8f9c3 Mon Sep 17 00:00:00 2001 From: CoprDistGit Date: Mon, 15 May 2023 05:33:51 +0000 Subject: automatic import of python-dbt2looker --- .gitignore | 1 + python-dbt2looker.spec | 332 +++++++++++++++++++++++++++++++++++++++++++++++++ sources | 1 + 3 files changed, 334 insertions(+) create mode 100644 python-dbt2looker.spec create mode 100644 sources diff --git a/.gitignore b/.gitignore index e69de29..8b28db4 100644 --- a/.gitignore +++ b/.gitignore @@ -0,0 +1 @@ +/dbt2looker-0.11.0.tar.gz diff --git a/python-dbt2looker.spec b/python-dbt2looker.spec new file mode 100644 index 0000000..4261679 --- /dev/null +++ b/python-dbt2looker.spec @@ -0,0 +1,332 @@ +%global _empty_manifest_terminate_build 0 +Name: python-dbt2looker +Version: 0.11.0 +Release: 1 +Summary: Generate lookml view files from dbt models +License: MIT +URL: https://github.com/hubble-data/dbt2looker +Source0: https://mirrors.nju.edu.cn/pypi/web/packages/9e/e9/30e36510fc149b5b92d44809e80f33fbdfebe2742ecd1b3ad839c4f7b48d/dbt2looker-0.11.0.tar.gz +BuildArch: noarch + +Requires: python3-lkml +Requires: python3-pydantic +Requires: python3-PyYAML +Requires: python3-typing-extensions +Requires: python3-importlib-metadata + +%description +# dbt2looker + +Use `dbt2looker` to generate Looker view files automatically from dbt models. + +Want a deeper integration between dbt and your BI tool? You should also checkout [Lightdash - the open source alternative to Looker](https://github.com/lightdash/lightdash) + +**Features** + +* **Column descriptions** synced to looker +* **Dimension** for each column in dbt model +* **Dimension groups** for datetime/timestamp/date columns +* **Measures** defined through dbt column `metadata` [see below](#defining-measures) +* Looker types +* Warehouses: BigQuery, Snowflake, Redshift (postgres to come) + +[![demo](https://raw.githubusercontent.com/hubble-data/dbt2looker/main/docs/demo.gif)](https://asciinema.org/a/407407) + +## Quickstart + +Run `dbt2looker` in the root of your dbt project *after compiling looker docs*. + +**Generate Looker view files for all models:** +```shell +dbt docs generate +dbt2looker +``` + +**Generate Looker view files for all models tagged `prod`** +```shell +dbt2looker --tag prod +``` + +## Install + +**Install from PyPi repository** + +Install from pypi into a fresh virtual environment. + +``` +# Create virtual env +python3.7 -m venv dbt2looker-venv +source dbt2looker-venv/bin/activate + +# Install +pip install dbt2looker + +# Run +dbt2looker +``` + +**Build from source** + +Requires [poetry](https://python-poetry.org/docs/) and python >=3.7 + +For development, it is recommended to use python 3.7: + +``` +# Ensure you're using 3.7 +poetry env use 3.7 +# alternative: poetry env use /usr/local/opt/python@3.7/bin/python3 + +# Install dependencies and main package +poetry install + +# Run dbtlooker in poetry environment +poetry run dbt2looker +``` + +## Defining measures + +You can define looker measures in your dbt `schema.yml` files. For example: + +```yaml +models: + - name: pages + columns: + - name: url + description: "Page url" + - name: event_id + description: unique event id for page view + meta: + measures: + page_views: + type: count +``` + + +%package -n python3-dbt2looker +Summary: Generate lookml view files from dbt models +Provides: python-dbt2looker +BuildRequires: python3-devel +BuildRequires: python3-setuptools +BuildRequires: python3-pip +%description -n python3-dbt2looker +# dbt2looker + +Use `dbt2looker` to generate Looker view files automatically from dbt models. + +Want a deeper integration between dbt and your BI tool? You should also checkout [Lightdash - the open source alternative to Looker](https://github.com/lightdash/lightdash) + +**Features** + +* **Column descriptions** synced to looker +* **Dimension** for each column in dbt model +* **Dimension groups** for datetime/timestamp/date columns +* **Measures** defined through dbt column `metadata` [see below](#defining-measures) +* Looker types +* Warehouses: BigQuery, Snowflake, Redshift (postgres to come) + +[![demo](https://raw.githubusercontent.com/hubble-data/dbt2looker/main/docs/demo.gif)](https://asciinema.org/a/407407) + +## Quickstart + +Run `dbt2looker` in the root of your dbt project *after compiling looker docs*. + +**Generate Looker view files for all models:** +```shell +dbt docs generate +dbt2looker +``` + +**Generate Looker view files for all models tagged `prod`** +```shell +dbt2looker --tag prod +``` + +## Install + +**Install from PyPi repository** + +Install from pypi into a fresh virtual environment. + +``` +# Create virtual env +python3.7 -m venv dbt2looker-venv +source dbt2looker-venv/bin/activate + +# Install +pip install dbt2looker + +# Run +dbt2looker +``` + +**Build from source** + +Requires [poetry](https://python-poetry.org/docs/) and python >=3.7 + +For development, it is recommended to use python 3.7: + +``` +# Ensure you're using 3.7 +poetry env use 3.7 +# alternative: poetry env use /usr/local/opt/python@3.7/bin/python3 + +# Install dependencies and main package +poetry install + +# Run dbtlooker in poetry environment +poetry run dbt2looker +``` + +## Defining measures + +You can define looker measures in your dbt `schema.yml` files. For example: + +```yaml +models: + - name: pages + columns: + - name: url + description: "Page url" + - name: event_id + description: unique event id for page view + meta: + measures: + page_views: + type: count +``` + + +%package help +Summary: Development documents and examples for dbt2looker +Provides: python3-dbt2looker-doc +%description help +# dbt2looker + +Use `dbt2looker` to generate Looker view files automatically from dbt models. + +Want a deeper integration between dbt and your BI tool? You should also checkout [Lightdash - the open source alternative to Looker](https://github.com/lightdash/lightdash) + +**Features** + +* **Column descriptions** synced to looker +* **Dimension** for each column in dbt model +* **Dimension groups** for datetime/timestamp/date columns +* **Measures** defined through dbt column `metadata` [see below](#defining-measures) +* Looker types +* Warehouses: BigQuery, Snowflake, Redshift (postgres to come) + +[![demo](https://raw.githubusercontent.com/hubble-data/dbt2looker/main/docs/demo.gif)](https://asciinema.org/a/407407) + +## Quickstart + +Run `dbt2looker` in the root of your dbt project *after compiling looker docs*. + +**Generate Looker view files for all models:** +```shell +dbt docs generate +dbt2looker +``` + +**Generate Looker view files for all models tagged `prod`** +```shell +dbt2looker --tag prod +``` + +## Install + +**Install from PyPi repository** + +Install from pypi into a fresh virtual environment. + +``` +# Create virtual env +python3.7 -m venv dbt2looker-venv +source dbt2looker-venv/bin/activate + +# Install +pip install dbt2looker + +# Run +dbt2looker +``` + +**Build from source** + +Requires [poetry](https://python-poetry.org/docs/) and python >=3.7 + +For development, it is recommended to use python 3.7: + +``` +# Ensure you're using 3.7 +poetry env use 3.7 +# alternative: poetry env use /usr/local/opt/python@3.7/bin/python3 + +# Install dependencies and main package +poetry install + +# Run dbtlooker in poetry environment +poetry run dbt2looker +``` + +## Defining measures + +You can define looker measures in your dbt `schema.yml` files. For example: + +```yaml +models: + - name: pages + columns: + - name: url + description: "Page url" + - name: event_id + description: unique event id for page view + meta: + measures: + page_views: + type: count +``` + + +%prep +%autosetup -n dbt2looker-0.11.0 + +%build +%py3_build + +%install +%py3_install +install -d -m755 %{buildroot}/%{_pkgdocdir} +if [ -d doc ]; then cp -arf doc %{buildroot}/%{_pkgdocdir}; fi +if [ -d docs ]; then cp -arf docs %{buildroot}/%{_pkgdocdir}; fi +if [ -d example ]; then cp -arf example %{buildroot}/%{_pkgdocdir}; fi +if [ -d examples ]; then cp -arf examples %{buildroot}/%{_pkgdocdir}; fi +pushd %{buildroot} +if [ -d usr/lib ]; then + find usr/lib -type f -printf "/%h/%f\n" >> filelist.lst +fi +if [ -d usr/lib64 ]; then + find usr/lib64 -type f -printf "/%h/%f\n" >> filelist.lst +fi +if [ -d usr/bin ]; then + find usr/bin -type f -printf "/%h/%f\n" >> filelist.lst +fi +if [ -d usr/sbin ]; then + find usr/sbin -type f -printf "/%h/%f\n" >> filelist.lst +fi +touch doclist.lst +if [ -d usr/share/man ]; then + find usr/share/man -type f -printf "/%h/%f.gz\n" >> doclist.lst +fi +popd +mv %{buildroot}/filelist.lst . +mv %{buildroot}/doclist.lst . + +%files -n python3-dbt2looker -f filelist.lst +%dir %{python3_sitelib}/* + +%files help -f doclist.lst +%{_docdir}/* + +%changelog +* Mon May 15 2023 Python_Bot - 0.11.0-1 +- Package Spec generated diff --git a/sources b/sources new file mode 100644 index 0000000..b290639 --- /dev/null +++ b/sources @@ -0,0 +1 @@ +1edfcdda0a01b80a66839005fea358af dbt2looker-0.11.0.tar.gz -- cgit v1.2.3