Questions tagged [unload]

29 questions
4
votes
1 answer

How to unload dynamic imports in javascript?

So basically, I have a json file that defines what to load when a user logs in. This includes javascript files. When a different user logs in, the previous stuff needs to be unloaded without a page refresh. I'm making use of the javascript dynamic…
GoblinCode
  • 41
  • 2
2
votes
1 answer

How to detect that Chrome Extension with Manifest v3 was unloaded

Our Chrome extension has both content and background scripts communicating with each other. When the plugin is updated, the background script is stopped and the content scripts start getting Error: Extension context invalidated.. In V2, we used…
2
votes
2 answers

How to add date to a file's name using UNLOAD in Redshift

I found 2 solutions: Using AWS Data Pipeline to schedule the query (Unload) and use 's3://reporting-team-bucket/importfiles/test_123-#{format(@scheduledStartTime,'YYYY-MM-dd-HH')}.csv' writing an MV command to rename the file on the s3 bucket Is…
Itay
  • 100
  • 7
1
vote
1 answer

DBT Redshift Unload Macro Failing

I am attempting to use the Redshift Package Macro for Unloading to S3. When I compile the code and run it directly in Redshift it works fine, but dbt keeps failing when I run model or build model. Here is the dbt code: {{ config( { …
1
vote
0 answers

Redshift Unload with replace in Airflow

I am trying to run sql query get_ns_inv_data = """ select invoice_number, invoice_line_id, invoice_date,invoice_type, maintenance_start_date, maintenance_end_date, substring(sf_invoice,0,8) sf_invoice, sf_opportunity_no, sf_order_no,…
tkansara
  • 534
  • 1
  • 4
  • 21
1
vote
0 answers

ERROR VuforiaEngine.pdb unloaded.... Why?

before starting i specify my english is not good "-" So lets go :D Actually i try to create a Mixed reality project. My objective build with unity and Visual stuid in Hololens (first model). I installed all librairies for that and i open a demo…
Law
  • 11
  • 2
1
vote
0 answers

How to detach formula.tools in R without restarting the session

I've loaded formula.tools in R. I now want to unload it, but when I run detach('package:formula.tools', unload = T) this package still affects the as.character function. See below for example. Can anyone advise how to unload formula.tools such that…
jruf003
  • 980
  • 5
  • 19
0
votes
0 answers

Multiple redshift unload table from dbt core

I am trying to loop through some values in dbt retrieved by a model and each time I am applying a filteron a value I want to execute an unload function to s3. So I am trying to create a different file for each filter. I am able to run the unload…
killumi_91
  • 11
  • 1
0
votes
0 answers

UNLOAD table DB2 with header With JCL

I'm doing UNLOAD of my DB2 table with JCL using dsntiaul. I want to UNLOAD my DB2 table with the name of columns on the first line of my dataset.
Ahmed SEDDIK
  • 149
  • 12
0
votes
0 answers

Redshift - Unload command - Parquet - Struct not resolving

I'm using the Redshift Unload command to unload a table to parquet into a target S3 bucket. I'm finding that my JSON columns - which are currently defined as a SUPER data type in redshift is not being serialized into a parquet struct. What this it…
KoEDeath
  • 1
  • 1
0
votes
1 answer

Snnowflake - COPY statement only supports simple SELECT from stage statements for import

I'm trying to unload data from my table from snowflake to s3, like this: COPY INTO "@DATABASE.SCHEMA.MY_STAGE/my_view/year=2023/month=04/day=21/my_view_data.parquet" FROM ( SELECT * FROM my_table WHERE to_date(event_time) =…
0
votes
0 answers

Amazon Redshift CLEANPATH option doesn't delete files until AFTER the UNLOAD

From all Redshift documentation / forums I've read, I understand the files in path are deleted before the unload. From UNLOAD - Amazon Redshift: CLEANPATH The CLEANPATH option removes existing files located in the Amazon S3 path specified in the TO…
0
votes
0 answers

How to remove unload listeners from jquery 3.5.1

After running lighthouse audit on my site - I see there are unload listeners in jQuery 3.5.1. I tried to replace unload/onunload with pagehide/onpagehide event - but lighthouse points to somewhere different in file? There don't seem to be an easy…
duerzd696
  • 304
  • 1
  • 8
0
votes
0 answers

alert inside unload event listener is not working in IE 11 browser

Below is the HTML code snippet where I am trying to display an alert during unload event. But I am not able to see the alert.
0
votes
1 answer

Unload from Redshift to S3 with multiple character delimiter

Can I unload from Redshift to an S3 bucket with a multiple character delimiter? For example to use a double pipe delimiter as below? Because when doing so the file created in S3 has only the first | as a delimiter and disregards the second. unload…
1
2