Before you begin

Make sure you have the required permissions to create a table in the Snowflake database used in the connection where you want to create your custom calendar.

Creating a custom calendar

To create a custom calendar, do the following:

  1. Click Data in the top navigation bar.

    The Data Objects page appears.

  2. Click the More menu more options menu icon, and select calendar icon Custom calendar.

    The Custom calendar page appears.

  3. Click Create Custom Calendar.

    The Create Custom Calendar dialog appears.

  4. For Calendar Name, enter a name for your calendar.

  5. Click the Choose Connection menu, and select the connection where you want to use your custom calendar.

  6. For Database, click the Choose a database menu, and select the database you want to use with your custom calendar.

  7. For Schema, click the Choose a schema menu, and select the schema you want to use with your custom calendar.

  8. Make sure Create new is selected.

  9. For Table, enter a name for the table that will be created for your custom calendar.

  10. For Start Date, enter the date you want your custom calendar to start.

  11. For End Date, enter the date you want your custom calendar to end.

  12. For Calendar Type, click the Choose a calendar type menu, and select the type of calendar you want to create. Possible types include:
    • MONTH_OFFSET
    • FOUR_FOUR_FIVE
    • FOUR_FIVE_FOUR
    • FIVE_FOUR_FOUR
  13. For Monthly offset, click the Choose monthly offset menu and select a month.

  14. For Start day of the week, click the Choose start day menu and select a day.

  15. For Quarter name prefix, enter the prefix you’d like to use for quarter numbers.

    Example: Q

  16. For Year name prefix, enter the prefix you’d like to use for years.

    Example: FY

  17. Click Create.

    The Custom calendar page appears again, with the message “Custom calendar created successfully!”

Update a custom calendar
Delete a custom calendar
Custom calendar overview
Fiscal and Gregorian calendars