Skip to main content

Data-modelling and processing framework for automating Python and SQL tasks

Project description

SAYN logo

SAYN is a data-modelling and processing framework for automating Python and SQL tasks. It enables analytics teams to build robust data infrastructures in minutes.

Status: SAYN currently supports UNIX operating systems (macOS, Linux).

Use Cases

SAYN can be used for multiple purposes across the analytics workflow:

  • Data extraction: complement tools such as Fivetran or Stitch with customised extraction processes.
  • Data modelling: transform raw data in your data warehouse.
  • Data science: integrate and execute data science models.

Key Features

SAYN has the following key features:

  • YAML based creation of DAGs (Direct Acyclic Graph). This means all analysts, including non Python proficient ones, can contribute to building ETL processes.
  • SQL SELECT statements: turn your queries into managed tables and views automatically.
  • Jinja parameters: switch easily between development and product environment and other tricks with Jinja templating.
  • Python tasks: use Python scripts to complement your extraction and loading layer and build data science models.
  • Multiple databases supported.
  • and much more... See the Documentation.

Design Principles

SAYN is designed around three core principles:

  • Simplicity: data models and processes should be easy to create, scale and maintain. So your team can focus on data transformation instead of writing processes. SAYN orchestrates all your tasks systematically and provides a lot of automation features.
  • Flexibility: the power of data is unlimited and so should your tooling. SAYN currently supports both SQL and Python so your analysts can choose the most optimal solution for each process.
  • Centralisation: all analytics code should live in one place, making your life easier and allowing dependencies throughout the whole analytics process.

Quick Start

$ pip install sayn
$ sayn init test_sayn
$ cd test_sayn
$ sayn run

This is it! You completed your first SAYN run on the example project. Continue with the Tutorial: Part 1 which will give you a good overview of SAYN's true power!

Support

If you need any help with SAYN, or simply want to know more, please contact the team at sayn@173tech.com.

License

SAYN is open source under the Apache 2.0 license.


Made with :heart: by 173tech.

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

sayn-0.4.1.tar.gz (222.4 kB view hashes)

Uploaded Source

Built Distribution

sayn-0.4.1-py3-none-any.whl (244.9 kB view hashes)

Uploaded Python 3

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