-
Why Aren't Record Counts Computable by Default?
In my DSS flows, I always activate record counts to check the volume of my datasets. However, it is cumbersome to activate them one by one, and it seems that it is not possible to activate them by default for an entire project. Why doesn't DSS allow this? Operating system used: RHL 8
-
SQL API ENDPOINT (Passing multiple values in test query)
Hi, I am trying to create a SQL API endpoint using a select query to my database. select * from table where state in (?) and city in (?) parameters param1, param2 The query works fine, however problem arises when i try to filter records for multiple values of a parameter. Just wanted to check where am i going wrong with…
-
DSS visual recipes defaulting to max column length with Redshift tables
Hi everyone, When working with Redshift tables in DSS visual recipes we noticed that the table creation settings sometimes defaults to setting certain column lengths to the redshift max (65,000). In many cases this becomes excessive. For example, in the screenshot below the "brand" column has a length of 65k but most of…
-
How to create a column with a unique ID value
Hi, I have 4 flow with different data information but with several companies in all flows. How can I create a column with a unique ID for each company? This way I can merge the flows together based on the ID. Thanks
-
Dataset type change error after python recipe
I'm using Python recipe (pandas) to edit column names of my dataset (names changed after pivot recipe). after python recipe type of one column changes. The problem is i get following error "The schema of the dataset does not match the table" * Type mismatch for column 1 (serial) : 'NVARCHAR' in dataset, 'DOUBLE'(8:float)…
-
Extracting Archive files
I'm trying to extract set of archive files with different formats like [".zip", ".7z", ".rar", ".tar", ".gz", ".bz2", ".xz", ".iso", ".ZIP", ".7Z", ".RAR", ".TAR", ".GZ", ".BZ2", ".XZ", ".ISO"] I was using 7z executable api to extract locally in python . I could see that there's no in built execution api like 7z. Is there…
-
Test Capability Custom Aggregation Group Recipe
I want to test capability custom aggregation in Group recipe, but it keeps getting me an error. ,Can you help? do you have some documentation regarding using custom aggregations? Operating system used: Almalinux (8.9)
-
Dataset icon grayed
Hi, Does anyone knows why dataset is grayed at the flow? Thanks Operating system used: win 10
-
Getting streamlit code studio to use the project code environment
Hi, I made a Python 3.8 code environment in dataiku that mimics the code environement I sue to run my streamlit app on my PC. However, the Streamlit app on dataiku seems to use a hard-coded code environment. Is there any way to configure this by the project owner? thx Operating system used: Windows 10
-
split formula for more than one delimiter
Hello everyone, I attempted to use the split function for the delimiter that has the value ",". However, I also need it to be split by the value "()". When using just the split function, I attempted to type in both the comma as the indicator and the parenthesis as the indicator, but it seems to be limited only to one and I…