Apply

A transform that accepts a custom template to execute. Must use the sql template argument source_table to reference the Rasgo dataset which will serve as the base of any SELECT

Parameters

Name	Type	Description	Is Optional
sql	custom	The custom SQL transform template to apply

Example

ds = rasgo.get.dataset(id)

ds2 = ds.apply(
  sql='SELECT * FROM {{ source_table }} WHERE COLUMNVALUE = I17'
)
ds2.preview()

# passing in custom arguments
ds = rasgo.get.dataset(id)

ds2 = ds.apply(
  sql="SELECT * FROM {{ source_table }} WHERE COLUMNVALUE = '{{ my_value }}'",
  my_value="I17"
)
ds2.preview()

Source Code

RasgoTransforms/rasgotransforms/rasgotransforms/transforms/apply/apply.sql at main · rasgointelligence/RasgoTransformsGitHub