Questions tagged with Analytics

Our current setup involves AWS Glue in operation, where data is being extracted from one SQL Server and loaded into another SQL Server through use of AWS Glue Studio for selected tables. Is there a...

Hi, We are currently investigating the use of the Timestream Athena connector (https://docs.aws.amazon.com/athena/latest/ug/connectors-timestream.html) as a way of enabling our data teams to work...

Hi, I have what I think is a pretty common use case, whereby I'd like to keep "hot" data in my Timestream table memory store for 30 days before moving this to "colder" magnetic storage for keeping...

I'm seeking guidance on a specific requirement and the recommended approach to achieve it. My data is currently stored in an AWS Aurora SQL database (let's say host1/db1) . The objective is to...

Hi All, Can we send the AWS Security hub events (from our account) to the security lake of a different organization/vendors account? seems it is a direct link between the security hub to...

I am working on a view in Athena, which requires being able to do the following, identify the time of each work experience, using the number of months, days and count how many jobs you have had in...

Hi All, I hope everyone is doing well! I am attempting to create a federated query between Redshift and Aurora Postgres 14. I am following the instructions on this page:...

Hi, The environment is, there are multiple JSON files in a S3 bucket. I would like to add all of them to the Athena Table with the filtered values. I used the ChatGPT for the Athena query to create...

Deployed 200 and 300 labs, including CUDOS, Cost Intelligence, and the Compute Optimizer Dashboard in Quicksight. The compute_optimizer_all_options dataset is refreshing daily but is ingesting the...

Getting this error ClientError: Quality check failed. while doing the data quality check with QualityCheckStep. and in the violation report "Data type match requirement is not met" getting this...

Hello, I'm writing a custom transform where I want to use mode within pyspark.sql.functions but I get the same issue irrespective of whether I use * or import the specific module. How can I resolve...

I am running pyspark on glue 3 notebook. The %additional_python_modules works well in the absence of %connections. But if I add %connections the job ignore %additional_python_modules and doesn't...