Data & Schema Discussions

Schema Naming Convention strategy

Does anyone have any good ideas on how to name their schemas and business schemas?We have different types of schemas - some pull data in externally, but others only use Alias tables from other schemas. We have some that serve very specific purposes ...

Data APIs for External Notebooks - save parquet

Hi All,I´m using external Jupyter notebook with python to capture data from Oracle database. Jupyter Notebook and Incorta server doesn´t share any storage location.I´ve downloaded the sample-notebook.ipynb notebook and I´m using it as example to conn...

Dense Snapshot Truncation?

I've read and implemented a dense snapshot table. It works exactly as expected. Yay!What I need now is a way to trim the snapshot. The start of the snapshot has a starting date way back when. I want to move that starting date forward so as to limit t...

Resolved! MV using Incorta SQL

Hi,I tried creating an MV using Incorta SQL as Data Source, but I keep getting below error as shown below. Can you help me understand when to use this particular type in creating MV's.INC_04030340: Materializing table failed because 109152Thanks,Srin...

Resolved! Plan for Spark Version 3.2

Hi all,I was wondering if there is a roadmap for the upgrade of Incorta Spark to version 3.2 or 3.3?The reason I ask is because Spark version 3.2 saw the implementation of Pandas API on Spark (https://spark.apache.org/docs/latest/api/python/user_guid...