Page

Configuring DATAPANCAKE Settings in Snowflake

Made by Ben Wolff with Scribearrow-up-right

1. Navigate to https://app.snowflake.com/ayieclp/tdaa_documentation/#/apps/application/DATAPANCAKE/schema/CORE/streamlit/DATAPANCAKE_HOMEarrow-up-right

2. Click here.

3. Click "udi_json"

4. Click the "Configuration Name*" field.

5. Type "Full Scan Multi Call"

6. Click here.

7. Click "DATAPANCAKE_MEDIUM_01"

8. Click the "Number of Procedure Calls*" field.

9. Click the "Record Count Per Procedure Call*" field.

10. Type "2500000"

11. Click the "Order By**" field.

12. Press [[cmd]] + [[v]]

13. Click "Save"

14. Switch to tab Pancake Regression Test Plan Template - Google Sheets"

15. Click "json_data:"_id""

16. Switch to tab DATAPANCAKE_HOME - DATAPANCAKE - Snowflake"

17. Click the "Configuration Name*" field.

18. Type "Partial Scan Where Clause 1"

19. Click the "Configuration Name*" field.

20. Click here.

21. Click "DATAPANCAKE_MEDIUM_01"

22. Click the "Where Clause" field.

23. Press [[cmd]] + [[v]]

24. Click the "Where Clause" field.

25. Click "Save"

26. Click the "Configuration Name*" field.

27. Type "Partial Scan Where Clause 2"

28. Click the "Configuration Name*" field.

29. Click here.

30. Click here.

31. Click "DATAPANCAKE_MEDIUM_01"

32. Click the "Record Limit" field.

33. Type "1000"

34. Click the "Record Limit" field.

35. Click the "Where Clause" field.

36. Press [[cmd]] + [[v]]

37. Click the "Where Clause" field.

38. Click "Save"

39. Click the "Configuration Name*" field.

40. Type "Partial Scan Order By Limit"

41. Click the "Configuration Name*" field.

42. Click the "Record Limit" field.

43. Click the "Order By**" field.

44. Press [[cmd]] + [[v]]

45. Click the "Order By**" field.

46. Click "Save"

47. Click the "Configuration Name*" field.

48. Click here.

49. Click the "Cron Schedule**" field.

50. Press [[cmd]] + [[v]]

51. Click the "Cron Schedule**" field.

52. Click here.

53. Click "America/New_York"

54. Click "Save"

55. Click here.

56. Click the "Record Limit" field.

57. Type "150"

58. Click the "Record Limit" field.

Made with Scribearrow-up-right

Last updated

Was this helpful?