在Google Cloud的推荐AI中导入用户事件

Question

我正在做Google Cloud的AI推荐。对于导入用户事件，它支持BigQuery，但找不到所需的表架构。由于它是Beta版，社区支持和文档是有限的。有人可以指导我创建用于从BigQuery导入用户事件的表模式吗？

Answer 1

正如您所看到的here，要从BigQuery导入数据，您应该使用Recommendations AI Schema。该模式是如下所示的JSON模式：

[
    {
        "name": "product_metadata",
        "type": "RECORD",
        "mode": "NULLABLE",
        "fields": [
            {
                "name": "images",
                "type": "RECORD",
                "mode": "REPEATED",
                "fields": [
                    {
                        "name": "uri",
                        "type": "STRING",
                        "mode": "REQUIRED"
                    },
                    {
                        "name": "height",
                        "type": "STRING",
                        "mode": "NULLABLE"
                    },
                    {
                        "name": "width",
                        "type": "STRING",
                        "mode": "NULLABLE"
                    }
                ]
            },
            {
                "name": "exact_price",
                "type": "RECORD",
                "mode": "REQUIRED",
                "fields": [
                    {
                        "name": "original_price",
                        "type": "FLOAT",
                        "mode": "NULLABLE"
                    },
                    {
                        "name": "display_price",
                        "type": "FLOAT",
                        "mode": "NULLABLE"
                    }
                ]
            },
            {
                "name": "canonical_product_uri",
                "type": "STRING",
                "mode": "NULLABLE"
            },
            {
                "name": "currency_code",
                "type": "STRING",
                "mode": "NULLABLE"
            }
        ]
    },
    {
        "name": "language_code",
        "type": "STRING",
        "mode": "NULLABLE"
    },
    {
        "name": "description",
        "type": "STRING",
        "mode": "NULLABLE"
    },
    {
        "name": "title",
        "type": "STRING",
        "mode": "REQUIRED"
    },
    {
        "name": "tags",
        "type": "STRING",
        "mode": "REPEATED"
    },
    {
        "name": "category_hierarchies",
        "type": "RECORD",
        "mode": "REPEATED",
        "fields": [
            {
                "name": "categories",
                "type": "STRING",
                "mode": "REPEATED"
            }
        ]
    },
    {
        "name": "id",
        "type": "STRING",
        "mode": "REQUIRED"
    }
]

值得一提的是，您还可以从Google Analytics导入数据。Google Analytics模式的参考可以在here中找到。