Stack Overflow
Stack Overflow

Questions tagged [alation]

Used to describe questions on the data cataloguing product - Alation

15 questions
2
votes
0 answers

Random and set seed to not working correctly in Redshift Alation Sql query

I have a T1 table with user_id and the date they created their account either in 2019 or 2018. I want to assign a random date to each user. For users in 2018 the random date can be anything in 2019, but for people registered in 2019 there random…
gulshan madhur
  • 21
  • 2
1
vote
0 answers

Resetting minimum value after certain condition is met

In Teradata, I want to add a date column that gives me the minimum date which would reset after a certain condition is met. In this case the min date is reset when the difference >= 60. Code initial table CREATE VOLATILE TABLE tbl_testing (id…
biguzs
  • 21
  • 4
1
vote
1 answer

Keyboard shortcuts in Alation

Is there a Ctrl+Enter keyboard shortcut in Alation to run a query, or a way to enable it? On Windows (running Alation Compose in browser mode), Shift+F5 runs the current statement, but unlike Toad or SQL Developer, Ctrl+Enter does nothing.
Abhinav
  • 11
  • 4
0
votes
0 answers

How can I autocomplete fields in Alation?

I work for a company that has a lot of data. Sometimes we need to fill in the same information in more than one equal field. For example, imagine that the column "person_id", which appears in table X, in table Y and in table Z, and that this column…
Letícia Augusta
  • 1
0
votes
1 answer

Alation Query form and parameter fails to pass multiple values

PLEASE NOTE There is another post from a few years back on this issue, but none of the responses solve this problem. The goal is to create an Alation SQL form that allows for the user to enter multiple comma separated keywords. The Alation guide…
u4carson
  • 11
  • 2
0
votes
0 answers

Problem with post request in Azure data factory

I am trying to make a post call to an alation api through Azure Data factory web request activity. Documentation : https://developer.alation.com/dev/reference/upload-logical-metadata#code-samples curl -X POST "${BASE_URL}/default/article" -H…
Mohit Leekha
  • 61
  • 11
0
votes
0 answers

Snowflake Service Account for Alation

Our organization is looking to bring on board the Alation product for data mining. To do so, Alation requires a service account in Snowflake to touch every database, every schema in Snowflake. Obviously this is very broad access and the org is…
Ray S
  • 1
0
votes
1 answer

Greoupby With Max() condition SQL Teradata

I need to groupby a function and return only rows that have max value for each variable that I choose. In this case the variables are user_id, and task. My input is shown in the table below: user_id task mx 123456 expecd 4.85 789101 Packing…
Caio Euzébio
  • 182
  • 1
  • 1
  • 10
0
votes
0 answers

No more spool space for query in Teradata

I am using Teradata database but I am quite new to its functioning. Could you please help me with making the below query more efficient so that it does not yield 'no more spool space' error? It is getting too heavy after I add the 2nd join. SELECT …
Pawels
  • 192
  • 2
  • 12
0
votes
2 answers

Alation Query Forms - Parameter not working with "IN" operator

I need to create a query form with an input parameter that accepts multiple string inputs. According to Alation's document "What is a query form? Do you have parameters?", the code is simple: for passing multiple values: select * from order_history…
Vesper Annstas
  • 88
  • 12
0
votes
1 answer

Alation APIs for getting column level metadata

How can I get column level metadata in Alation? I was able to do it for datasource and schema level using Alation APIs but I facing difficulties in getting to the column level. Please help me on this.
Gaurav Malhotra
  • 17
  • 7
0
votes
1 answer

I want to do a calculation inside a select from specific data of the same column. Is this possible?

I want to do a SUM calculation who calls multiple times my 'Q' and QBUYERS column, but within different rows this is my table: group type Q QBUYERS GROUP1 sent 300 200 GROUP2 shown 400 100 GROUP3 sent 200 150` And this is…
pachuzzz
  • 1
  • 1
0
votes
1 answer

Error --> Can someone explain (to a newbie) how to join outside of a sub-query within a select statement?

Code: select cal.fiscal_week, h.role_type, h.se, sub.* from ( select ds_denali__call_disposition__c as disposition, datepart(hour, dateadd(hour, -5, ds_denali__call_started__c)) as call_time, datepart(dw,…
Mina
  • 3
  • 2