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. The SQL endpoint refuses the clients it cannot authenticate: the session must set atoti.SessionConfig.security, and each SQL user must be granted a role with individual_roles.

>>> 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