Data & Schema Discussions

Resolved! Leading Spaces during Column extraction

Hi,When I extract a column from Oracle DB, the leading spaces within the column values are removed by default. Is there a way to extract the value as it is (with leading spaces) from source?Version: 5.1.4 (On-Prem)Thanks,Srinivas

Resolved! Incorta 5 Essentials Self-Paced Free

Hi AllI am New to Incorta. Started Incorta 5 Essentials Self-Paced Free. Everything is working Fine Lab & Tutorial.When I reached the TOUR 04: Explore Data where I drag & drop Name for ProductCategory (Category) in the Grouping Dimension, Name for St...

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...