Microsoft Fabric
Overview​
Mitzu connects to Microsoft Fabric by using email/password authentication.
Supported data types​
Mitzu will map the types of the data warehouse based on the following table:
| Mitzu type | Data warehouse type |
|---|---|
| String | char, varchar |
| Number | bit, smallint, int, bigint, decimal, numeric, float, real |
| Boolean | Currently not supported |
| Datetime | date, time, datetime2 |
| Map | Currently not supported |
| Struct | Currently not supported |
| Array | Currently not supported |
info
All unrecognized types will be handled as strings.
Configure the connection details in Mitzu​
Please fill out the form with the details of your connections.
note
When entering URLs in our system, please include only the "Host" portion, omitting the protocol scheme like https.
Click the Test connection button to check if Mitzu can connect to your data warehouse using the entered values.
warning
Mitzu will try to connect to your data warehouse and execute a
SELECT 1;command. You may need to grant further permission Mitzu to see and query your data tables.To save the settings, click the Test connection & Save button.
Next steps​
Once the connection is tested an saved the event end dimension tables can be configured. Please follow the setting up event tables guide.