Introduction
Materialized Views in Incorta give lots of flexibility for end users to work with data in a language of their choice. Users working with PySpark often leverage Pandas DataFrames and want to save resulting DataFrames as tables in Incorta....
Introduction
Let's get up and running quickly with the Incorta Cloud. With Incorta Cloud, you can start analyzing your own data or sample data in minutes. In this article we will walk through the steps to create an Incorta Cloud account, connect to d...
Introduction
When creating visualizations based on multiple source systems, tables must be aligned to achieve a wholistic view of a business. For example, organizations that migrate from one ERP to another align invoice tables from each ERP to see al...
Introduction
In order to achieve a holistic view of business operations, it is common for organizations to unify similar data from disparate sources. This is often required after an ERP migration, company acquisition, or migration of data from on-pre...
Introduction
We often use presentation variables to allow our users to customize dashboard insights allowing for self-service and flexibility. These variables can update filters, aggregation methods, formatting options and much more. It is common to ...
Hi @rajib76 ,
I have not used looker in the past, but it looks like a a PostgreSQL database can be connected. Incorta does not store data in a PostgreSQL database but instead presents data through the analytics service using a PostgreSQL connection. ...
Hi @sambasiva - are you attempting to load data from a SQL Server/PostgreSQL server into your Incorta cloud instance? If so, here are the steps to connect to a PostgreSQL database and load data into a schema.
As long as you have the right permissions...
Here is a video of a code-friendly solution! The script for the MV using PySpark is in the description. Hope you enjoy!
https://www.youtube.com/watch?v=Xj6FpwT4fp8
Not the most elegant, but I got the end result! Here is my solution:
Create analyzer table named MONTHLY_REVENUE with 3 columns: Year, Month, RevenueCreate analyzer table named PREVIOUS_MONTHLY_REVENUE with 3 columns: Year, Month, Previous Month Reve...
.png "Employee"){kind=icon}
