-
Read trailing 14 days data from a partitioned S3 location as /load_date=YYYY-MM-DD/load_hour=HH
I want to read the trailing 14 days data from S3. I have already setup my S3 connection and want to read data for last 14 days load date and only the 24th load_hour. How can I apply filter just while reading the S3 location using S3 connection setup. Since I need to do it for multiple data sources reading it individually…
-
[Simba][AthenaJDBC](100071) An error has been thrown from the AWS Athena client. TABLE_NOT_FOUND
I am reading data from S3 location but I am not able to use it unless I sync it first. Syncing this huge data takes lot of time. What is the best way to avoid this issue without syncing it?
-
Webscraping with Dataiku
Hello, everybody! I have a working program in Python that I use to go through switch devices online, and it returns a CSV with all the information I need to perform an analysis. I tried to transfer the code from a server I was using to run this program to Dataiku, but I encountered an error while running pyautogui (which I…
-
Date Parsing
I have a requirement to trunc time of the date as below. Any event occurring after 12:00:00 is truncated to 12:00:00 before 12:000 is truncated to 12:00:00 Could not create Computed column matching below requirement Date Formatted Date 2024-11-21 13:00:00 2024-11-21 12:00:00 2024-11-21 11:00:00 2024-11-21 00:00:00…
-
how to create index
I want to assign IDs to unique dates in ascending order like 1,2,3... Please tell me how to create it without writing any code.
-
Getting the below error when trying to ping of the SFTP folders in the dataiku instance:
Getting the below error when trying to ping of the SFTP folders in the dataiku instance: SSH error connecting to ftp1.str.com, caused by: JSchAlgoNegoFailException: Algorithm negotiation fail: algorithmName="server_host_key"…
-
Push to editable recipe
Hello, Could you take an example to use "Push to editable" recipe? It seems like group or windows.. What exactly is it used for?
-
"CASE types double precision and character varying cannot be matched" error in prepare recipe
I get the above error in prepare recipe, not trying to match anything.
-
Python API for fleet manager
Hi all, I am trying to connect to the FMClientAWS using the documentation here : But I am not sure what to use as key_id and key_secret. I could not find anything related to this in the FM UI. Can anyone help me with how to get these two values for my FM? Thanks! Operating system used: linux Operating system used: linux
-
SSH error connecting to ftp1.str.com, caused by: JSchAlgoNegoFailException: Algorithm negotiation fa
Getting the below error when trying to ping of the SFTP folders in the dataiku instance: SSH error connecting to ftp1.str.com, caused by: JSchAlgoNegoFailException: Algorithm negotiation fail: algorithmName="server_host_key"…
