Skip to main content

generates lookml from a warehouse

Project description

wh_lookml_gen

https://img.shields.io/pypi/v/wh_lookml_gen.svg https://img.shields.io/travis/lewischarlesbaker/wh_lookml_gen.svg Documentation Status

generates lookml from a warehouse

Features

### bq_lookml_generator v.0.1.1

This automatic generator is buit over Josh Temples looker parser [https://github.com/joshtemple/lkml]. Building out lkml, it allows you to generate lookml from BigQuery metadata.

## getting started

  • make sure you are working in a venv.

  • pip install lookml_gen

  • config params
    • run lookml_gen_init
      • head to .lookml_gen and input your wh credentials
        • warehouse configs
          • either input big_query or red_shift (current support warehouses) under warehouse_name

          • input schema name

          • input project name

        • security
          • big_query
            • input your keyfile path

          • red_shift
            • input you credentials

  • input your warehouse schema target in here lookml/bq_lookml_gen/warehouse_target.py

  • type lookml_gen into terminal and watch the base explore generate…

## troubleshooting

  • run pip install -r requirements.txt if you are running into dependency issues

  • you can run bq_lookml_gen.py from terminal if needed

## to update

twine upload

–skip-existing dist/*

## to develop

  • add new features to setup tools using: python setup.py develop

rebuild the wheel

python setup.py sdist bdist_wheel

pip install -e /Users/lewisbaker/Documents/GitHub/kaplan_data_warehouse/lookml/lookml_gen/lookml_gen.py

pip freeze > requirements.txt

cat requirements.txt

Credits

This package was created with Cookiecutter and the audreyr/cookiecutter-pypackage project template.

History

0.1.7 (2021-05-28)

  • First release on PyPI.

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

wh_lookml_gen-0.1.7.tar.gz (11.9 kB view details)

Uploaded Source

Built Distribution

wh_lookml_gen-0.1.7-py2.py3-none-any.whl (7.5 kB view details)

Uploaded Python 2 Python 3

File details

Details for the file wh_lookml_gen-0.1.7.tar.gz.

File metadata

  • Download URL: wh_lookml_gen-0.1.7.tar.gz
  • Upload date:
  • Size: 11.9 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.4.1 importlib_metadata/3.9.0 pkginfo/1.7.0 requests/2.23.0 requests-toolbelt/0.9.1 tqdm/4.60.0 CPython/3.7.3

File hashes

Hashes for wh_lookml_gen-0.1.7.tar.gz
Algorithm Hash digest
SHA256 cbc0f583ca039576ac667fbf9c12792ec235159019738576eaf382d841505a0f
MD5 bce19ce295d52a178f19c095adc696a2
BLAKE2b-256 8ae6ebff8b24c69f389c96c3704b267f18d51546ac225d19d8b1e1b8904e5637

See more details on using hashes here.

File details

Details for the file wh_lookml_gen-0.1.7-py2.py3-none-any.whl.

File metadata

  • Download URL: wh_lookml_gen-0.1.7-py2.py3-none-any.whl
  • Upload date:
  • Size: 7.5 kB
  • Tags: Python 2, Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.4.1 importlib_metadata/3.9.0 pkginfo/1.7.0 requests/2.23.0 requests-toolbelt/0.9.1 tqdm/4.60.0 CPython/3.7.3

File hashes

Hashes for wh_lookml_gen-0.1.7-py2.py3-none-any.whl
Algorithm Hash digest
SHA256 3cd575a0f2b08daf4e67d11366e6a4310856c73ca4c9a2b23a2be70e2ea82add
MD5 530c522c7fcb4efcf425416b383520fd
BLAKE2b-256 089c2413693c22d77b23ebaaba3f524cc0a43a0ae4f4d16a4781b99ae4cf1f36

See more details on using hashes here.

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page