-
How do I get the average of a column to use in a DSS output file (not a metric)
I have a small table that gives me the average # of workdays, average daily value, and average forecast for the previous 3 months. I have to be able to calculate the average of each column so I can use the results in another prepare recipe (for example, the average of Workdays is 22). Is there a formula that will create…
-
Keeping Conditional Formatting While Export Doesn't Work.
I have an issue with the Applying conditional Formatting while export. Dataiku does not apply formatting while export. What is the issue how can i keep conditional formatting.
-
Label Encoding Dataiku Recipe
Hello, I cannot find any recipe that is the equivalent of the scikit learn LabelEncoder(). The One Hot encoding recipe can be found in prepare recipe as "Unfold" step but regarding LabelEncoder (IE label_1 = 1, label_2 = 2 … label_N = N) is very well hidden. I could make a python recipe but i would prefer to every task in…
-
If the dataset do not exists, I either want to catch this exception thrown, or check if df exists
Exception: Reading dataset failed: b"Failed to read data from table, caused by: SnowflakeSQLException: SQL compilation error:\nObject 'PROD_.GLOBAL_PILOT' does not exist or not authorized."
-
Dataiku visual Recipe Parallel
I am using Dataiku 12.5.2. How can I enable parallel processing when using a Sync recipe for the following cases: Filesystem Dataset to Filesystem Dataset JDBC Dataset to JDBC Dataset Or between Filesystem Dataset and JDBC Dataset? Are the only available options duplicating the flow, partitioning the data, or using code…
-
Leveraging Dataiku Instance from outside the environment.
I've tried using dataiku managed instance from local workstation using dataiku API client v13.1.4 and had trouble accessing projects in the machine. import dataikuapi import random import requests requests.packages.urllib3.disable_warnings() client = dataikuapi.DSSClient(DATAIKU_URL, API_KEY) project_keys =…
-
Is there a way to copy a dashboard to another project?
I have a dashboard in our QA environment to develop that I then want to publish to our prod instance. so Ideally I wanted a way to export the dashboard and then import in the other instance. Operating system used: Windows
-
Dataiku Automation For Excel File Refresh
Hello, I have an excel file which is connected to SQL DWH. Normally everyday, I go in this file to refresh data manually by clicking ctrl + alt + f5. I want to make it automatically with Dataiku. pip install pywin32 import win32com.client as win32 def refresh_excel_file(file_path): # Open Excel excel =…
-
Dataiku Python notebook kernel error.
Hi Dataiku Expert, We got a kernel error when starting a python notebook in Dataiku. The error message shows below. It is strange that it only happens to certain users. For the same notebook, one user can start and connect to the kernel without issue, but the affected user will get this kernel error. Both tested users have…
-
How to share objects using the Dataiku API
Hi, It appears that the settings.add_exposed_object() method is undocumented. So documenting here few examples for the benefit of others: import dataiku client = dataiku.api_client() project = client.get_project(source_project_key) settings = project.get_settings() # Share Managed Folder…
