-
SqlExecutor2 does not handle Snowflake ARRAY data type * Bug?
Hello, I am using the SQLExecutor2 to read a temporary table and write to a Snowflake dataset in a Python recipe. Here is the column data type: {"type":"ARRAY","length":16777216,"byteLength":16777216,"nullable":true,"fixed":false} Here is my Python code: Expression type does not match column data type, expecting…
-
Copying / saving Checks and metrics
Hello, Is there any way to copy checks and metrics from one data set to another? Is it possible to save a custom code check as a plugin ? Operating system used: Centos 7
-
Interacting with Labeling Task through Python API
Hello, In my project, I am trying to do two different things with labelings tasks. 1- Automatically create a labeling class according with a registry dataset with the classes that should exists. 2- Get the URL of the labeling class though a Python API to send to slack webhook. This is a issue since I need to send the…
-
Delete a partition
Hi, can anyone please help me on deleting a partition, i have created a dataset having many partitions and unfortunately one of the partition is loaded incorrectly and i would like to delete only partition and maintain the remaining same. please help on this, as i am unable to get any options to delete this.
-
Sorting dates in Pivot Tables
Hey everyone! I created one Pivot Table as an Insight to include it in my Dashboard. The Dataset has a date column. It is parsed correctly and the Insight has recognised the field as date. In the dataset, the table is ordered by the date field Descending. However, when I create the Insight with the Pivot Table, the only…
-
How to access specific check results in a scenario
I have a simple dataset containing 1 row and about 20 columns. Each column represents a Boolean value of whether or not a particular threshold has been breached. If the result is true for any of the 20 columns, then a message is sent to a designated MS Teams Channel that a breach has occurred. I would like to supplement…
-
Using date variables
Hi, I'm wanting to store a date in the project variable list, but can't figure out how to make the variable read as a date in, say, a formula step in a recipe. I've tried to format the date as "yyyy-MM-dd" with and without quotes, as well as "yyyy-MM-ddT00.00.00.000Z" with and without quotes. When I do the simple date…
-
Default variable values in an Application
Inside an Application, I define an "Edit project Variables" section, followed by my variable definitions: an "INT" and a "STRING". =========== [ { "name": "welcome", "label": "on", "defaultValue": "5.2 is my game", "mandatory": true, "canSelectForeign": false, "markCreatedAsBuilt": false, "allowDuplicates": true,…
-
evaluation store
can we use evaluation store output for further processing using python recipe.
-
How to prevent DSS replace NA with null?
Hi, I'm using Python recipe to query and insert data to the output SQL Server dataset as below. import dataikuimport pandas as pdfrom dataiku import SQLExecutor2# Read recipe inputsp787PDMItem = dataiku.Dataset("_P787PDMItem_src")p787PDMItem_df = p787PDMItem.get_dataframe()# Initialize an empty DataFrame to collect all…
