Skip to main content

this package leverages josh temples looker parser [https://github.com/joshtemple/lkml] so that you can generate lookml from BigQuery metadata

Project description

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

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.3.tar.gz (2.5 kB view details)

Uploaded Source

Built Distribution

wh_lookml_gen-0.1.3-py3-none-any.whl (3.0 kB view details)

Uploaded Python 3

File details

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

File metadata

  • Download URL: wh_lookml_gen-0.1.3.tar.gz
  • Upload date:
  • Size: 2.5 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.3.tar.gz
Algorithm Hash digest
SHA256 bc14e68ddde7b82618e60e4c77691ae752e2aa657c63301667975fd8d37f9aa1
MD5 cfbd96a1878645fba5ff225ac1ba16fc
BLAKE2b-256 0d89a06eeaba5ba9b22e7af81174c0646d2cd927c7dd98e9e4b0ec04fdc45b56

See more details on using hashes here.

File details

Details for the file wh_lookml_gen-0.1.3-py3-none-any.whl.

File metadata

  • Download URL: wh_lookml_gen-0.1.3-py3-none-any.whl
  • Upload date:
  • Size: 3.0 kB
  • Tags: 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.3-py3-none-any.whl
Algorithm Hash digest
SHA256 8dc8251d29710c356717a729bd13a85272592bdcf6d22f14d88667bbacce657f
MD5 ac33451c455bad25db74172217da29ed
BLAKE2b-256 7c0e40a10ff19f0436980738f14f1c9925675eddf38bed5543690a56a10b77b1

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