atoti_sql_bridge

Client part of the plugin to connect Tableau and Power BI to Atoti sessions.

Not available in the community edition: upgrade to use it.This feature requires a license that enables the bi-adapter component.

Tableau and Power BI can query an Atoti session: it exposes each of its cubes as a SQL table, over the PostgreSQL wire protocol. Only the SQL generated by these two tools is supported. BI tools connect with a username and password, which are checked like any other username and password login of the session, such as the ones set in credentials.

>>> table = session.read_pandas(
...     pd.DataFrame({"ID": ["foo"]}), keys={"ID"}, table_name="Example"
... )
>>> cube = session.create_cube(table)

>>> path, _ = session.client.get_path_and_version_id("activeviam/bi-adapter")

The host is the one the BI tool will use to reach the SQL endpoint:

>>> body = {"host": "localhost"}

>>> session.client.http_client.post(
...     f"{path}/tableau/tds/{cube.name}", json=body
... ).status_code
200
>>> session.client.http_client.post(
...     f"{path}/powerbi/pbit/{cube.name}", json=body
... ).status_code
200

Members

Name	Summary
`SqlBridgeConfig`	Configuration of the SQL endpoint that BI tools connect to.

Releases and upgrades

Install and start

Guides

Members

​Members

Members