cubetl | data ETL in Python | SQL Database library

by jjmontesl Python Version: Current License: MIT

X-Ray Key Features Code Snippets Community Discussions(1)Vulnerabilities Install Support

kandi X-RAY | cubetl Summary

cubetl is a Python library typically used in Database, SQL Database applications. cubetl has no bugs, it has no vulnerabilities, it has build file available, it has a Permissive License and it has low support. You can download it from GitHub.

CubETL is a tool for data ETL (Extract, Transform and Load). CubETL provides a mechanism to run data items through a processing pipeline. It takes care of initializing only the components used by the process, manages the data flow across the process graph, logging and cleanup. It can be used as a tool or from Python code. It provides out-of-the-box components that handle common data formats and it also includes SQL and OLAP modules that understand SQL and OLAP schemas and map data across them. This allows CubETL to insert OLAP facts across multiple tables in a single store operation, while automatically performing (and caching) the appropriate lookups. CubETL can also inspect an existing relational database and generate an OLAP schema, and the other way around. It can also produce configuration for Databrewery Cubes Server. All together it allows for a quick analytical inspection of an arbitrary database (see the examples below). Note: This project is in development stage and is tested in few environments. Documentation is incomplete. You will hit issues. Please use the issue tracker for bugs, questions, suggestions and contributions.

Support

Quality

Security

License

Reuse

Support

cubetl has a low active ecosystem.

It has 18 star(s) with 10 fork(s). There are 3 watchers for this library.

It had no major release in the last 6 months.

There are 3 open issues and 6 have been closed. On average issues are closed in 42 days. There are 3 open pull requests and 0 closed requests.

It has a neutral sentiment in the developer community.

The latest version of cubetl is current.

Quality

cubetl has no bugs reported.

Security

cubetl has no vulnerabilities reported, and its dependent libraries have no vulnerabilities reported.

License

cubetl is licensed under the MIT License. This license is Permissive.

Permissive licenses have the least restrictions, and you can use them in most projects.

Reuse

cubetl releases are not available. You will need to build from source code and install.

Build file is available. You can build the component from source.

Installation instructions, examples and code snippets are available.

Top functions reviewed by kandi - BETA

kandi has reviewed cubetl and discovered the below as its top functions. This is intended to give you an instant insight into cubetl implemented functionality, and help decide if they suit your requirements.

Add cubetl configuration
Add a component to the context
Import a configuration file
Retrieve component by uid
Parse command line arguments
Split a key value pair
Print usage information
Process the CSV data
Copy a message
Process Osmium files
Start the process
Process the given m
Perform lookup
Parse the url and store the result
Performs regexp search
Process the xpath extraction
Add default configuration
Process a message
Yields all files in the given directory
Interpolate country data
Process the JSON data
Launch the given component
Convert an SDMX dataset into a list of attributes
Insert row data
Run a query
Process a model
Process the data received from the API

Get all kandi verified functions for this library.

cubetl Key Features

No Key Features are available at this moment for cubetl.

cubetl Examples and Code Snippets

No Code Snippets are available at this moment for cubetl.

Community Discussions

Trending Discussions on cubetl

Mondrian rolap schema upgrader

QUESTION

Mondrian rolap schema upgrader

Asked 2018-Aug-01 at 08:43

I have mondrian xml schema (3 version). When I'm using my schema(v3) in mondrian 4 - it automatically trying to convert my schema throught RolapSchemaUpgrader. But during convertation it throws exception:

...

ANSWER

Answered 2018-Aug-01 at 08:43

I figured out the problem. In my case I had to add primaryKey attribute for each Hierarchy. Documentation told us:

If not specified, the key of the lowest level is used.

but it didn't work for me.

Source https://stackoverflow.com/questions/51614914

Community Discussions, Code Snippets contain sources that include Stack Exchange Network

Vulnerabilities

No vulnerabilities reported

Install cubetl

While CubETL is in development no pip packages are provided, and it should be installed using python setup.py develop. Using a virtualenv or docker instance is recommended.

Support

[Quickstart](https://github.com/jjmontesl/cubetl/blob/master/doc/guide/cubetl-quickstart.md)[Configuration](https://github.com/jjmontesl/cubetl/blob/master/doc/guide/cubetl-config.md) (includes, expressions, functions, library) <!-- * Running (-q, -d, -m, -p, standard input, redirecting, tty vs. non-tty, from Python, running several nodes) -→Sequential formats (text files, CSV, JSON…)[Tables](https://github.com/jjmontesl/cubetl/blob/master/doc/guide/cubetl-tables.md)Process flow (unions, chain forks, repeats…)[SQL](https://github.com/jjmontesl/cubetl/blob/master/doc/guide/cubetl-sql.md)[OLAP](https://github.com/jjmontesl/cubetl/blob/master/doc/guide/cubetl-olap.md)Script nodes, custom functions, custom nodes and custom components[Datetime](https://github.com/jjmontesl/cubetl/blob/master/library/datetime.py)[Geo](https://github.com/jjmontesl/cubetl/blob/master/library/geo.py)[Net](https://github.com/jjmontesl/cubetl/blob/master/library/net.py)[HTTP](https://github.com/jjmontesl/cubetl/blob/master/library/http.py)[Person](https://github.com/jjmontesl/cubetl/blob/master/library/person.py)[Components](https://github.com/jjmontesl/cubetl/tree/master/cubetl)See "Example ETL processes" above

Find more information at: