Search
GRIDSZ
Contact us
Request demo
GRIDSZ

Introduction to Info warehouse

Gridsz Info is a convenient data warehouse from which all data can be retrieved. Making it the single source for all relevant management information. By connecting your own data warehouse to Gridsz Info, you can eliminate the cumbersome processes of exporting & importing various files from numerous locations. 

Additionally, Gridsz Info supports creating data marts specifically tailored to the business needs, which is only accessible for that customer. This further simplifies the process, as Gridsz Info ensures that the data mart only contains data which is requested by and relevant to the data user. 

Gridsz Info uses Snowflake as its Cloud Data Platform which allows users to also connect using native Snowflake connectors from applications such as Power BI or Tableau. The data can also effectively be retrieved via our GraphQL, the GraphQL schema is tailored and dedicated to each customer individually, bound by the available data fields in each data mart. 

Getting started

Once a datamart is setup for you (the details of the datamart are discussed during the implementation phase), e.g. for the Workflow module, Gridsz shall supply you with the necessary details to connect, this means for: 

  • Native Connector: account details 
  • GraphQL: your schema, endpoint, bearer token, and IP Whitelisting 

Info does not have general user interface (GUI) and is purely API (or Native Connector) accessible. However, Info is the module which feeds the Gridsz dashboard on the landing page. This is a demonstration of the data available to Info and what kind of reporting is possible with this data. 

High Level Setup overview 

GraphQL

Each customer will receive their own GraphQL schema which contains relevant information on the fields that can be queried. This also contains the endpoints for both the acceptance and production environment.

Once authorized, the user can use Introspection to effectively find out all various available queries, filters, and more. This greatly improves the overall understanding of the schema while also reducing the time spent to integrate.

An example of a Gridsz Info schema can be downloaded as a txt file.

An example query would look like this:

With a sample response:

Native Power BI Connector

Power BI connects seamlessly to your Snowflake datamarts via the Snowflake connector in Power Query. Supported modes include Import and DirectQuery. Since July 2025, the connector uses implementation 2.0 (ADBC-based) by default, offering improved performance and security.

Setup Steps (Desktop): 

  • In Power BI Desktop, click Get Data → Database → Snowflake. 
  • Enter Snowflake Server and Warehouse, optionally set advanced options like Role or SQL timeouts. 
  • Choose Import or DirectQuery. 
  • Authenticate using Username/Password or Microsoft Entra ID (SSO). 

Connector 2.0: 

  • Faster, more secure (ADBC driver). Users may specify Implementation=”2.0″ in their M code if needed.  

Power BI Service & SSO: 

  • Use Microsoft Entra ID (OAuth). Requires configuration in both Power BI Tenant and Snowflake (via CREATE SECURITY INTEGRATION) to enable SSO functionality. 

Native Tableau Connector

Tableau provides a built-in connector to Snowflake, supporting multiple authentication methods, including OAuth, key-pair, Okta, and username/password.

Setup Steps: 

  • In Tableau Desktop, select Snowflake from the Connect pane (ODBC driver v3.4.0+ required). 
  • Provide the Server (full URL), Warehouse, Database, Schema (optional), and Username.  
  • Choose authentication method: OAuth, SSO via IdP, key-pair certificate, or programmatic token.  
  • (Optional) Add initial SQL, driver parameters, or configure OAuth as appropriate. 

Enterprise Security: 

  • Tableau Desktop ≥2020.4 supports PrivateLink and embedded OAuth. 
  • Tableau Server ≥2024.2 requires Custom OAuth integration. 
  • Snowflake supports external OAuth/IDP federation starting from Tableau 2024.3.