Skip to main content

Intro

The Lakehouse allows users and applications to easily access, analyze, and transform data in one central place. It helps turn raw data into meaningful insights, making it simpler to create reports, explore information, and support everyday decision-making using tools like Power BI.

How The Lakehouse Works​

There are two ways to access the Lakehouse: directly by users or through applications.

  • Direct user access is the fastest and simplest option when you just want to explore, analyze, or validate data.

  • Application access, on the other hand, provides a more structured and flexible way to work with the data, enabling integration with other systems and supporting broader use cases.

Users​

  1. Registration: In your Eloverde account at web.eloverde.com.br, go to Platform Integrations → Lakehouse → Include Button → Select User Access.

  • Access will be granted to the user creating the credential.

  • Give it a description.

  • Save it.

  1. Confirmation: This registration process generates a Microsoft invitation sent to the email address registered in Eloverde. The user must accept this invitation to gain access to the Lakehouse. If the email is not received or the invitation link has expired, please contact the support team.

  2. Usage: After confirming, please allow 30 to 45 minutes for the changes to be applied by Microsoft.

  • Once the update is complete, the user should access the Lakehouse through Microsoft Fabric using the email registered on Eloverde.

  • Within the environment, navigate to the Main workspace. There, you will find the Datalake folder, which provides access to our SQL Endpoint named Eloverde_Datalake.

Applications​

  1. Registration: In your Eloverde account at web.eloverde.com.br, go to Platform Integrations → Lakehouse → Include Button → Select Application Access.

  • Give it a description.

  • Save it.

  1. Usage: After saving it, please allow 30 to 45 minutes for the changes to be applied by Microsoft.
  • When you return to the Lakehouse page, you will see two important credentials: Client Id and Client Secret. These correspond to the application ID and application secret required to authenticate the connection with Microsoft Fabric. Once you have these credentials, you can proceed to the next step.

Setting Up An App​

To query the data, you will need:

  • An ODBC driver installed on your machine.
  • An ODBC client library in your target language.
    • For Python, install the pyodbc package to create and manage ODBC connections.

Credentials:​

tenant_id = "51036022-f506-40ca-91f5-83f22970fb98"
client_id = <your client id>
client_secret = <your client secret>
sql_endpoint = "ejqaguig6xfebepvqpzcs4h3ta-jspl5n72wrtelhkim7difrhqca.datawarehouse.fabric.microsoft.com"
database_name = "Eloverde_Datalake"

Querying​

After having the necessary credentials and token, you can query for information like this:

import pyodbc

conn_str = (
    f"Driver={{ODBC Driver 18 for SQL Server}};"
    f"Server=tcp:{sql_endpoint},1433;"
    f"Database={database_name};"
    f"UID={client_id};"
    f"PWD={client_secret};"
    f"Encrypt=yes;"
    f"TrustServerCertificate=no;"
    f"Authentication=ActiveDirectoryServicePrincipal;"
)

conn = pyodbc.connect(conn_str)
cursor = conn.cursor()

cursor.execute("SELECT TOP 10 * FROM [prod_saas].[table_name]")
rows = cursor.fetchall()

for row in rows:
    print(row)

Need Help?​

If you encounter any issues or have questions about implementing apps, please contact our support team through your Eloverde account or visit our help center.