GMaps Review Setup Recipe

cast(ds.text, {
    "type": "text"
}) => (ds.text)

configure_column_visibility(ds.address, {
    "details": "hidden",
    "graph": "hidden"
})

configure_column_visibility(ds.categoryName, {
    "details": "hidden",
    "graph": "hidden"
})

configure_column_visibility(ds.imageUrl, {
    "details": "hidden",
    "graph": "hidden"
})

configure_column_visibility(ds.location_lat, {
    "details": "hidden",
    "graph": "hidden"
})

configure_column_visibility(ds.location_lng, {
    "details": "hidden",
    "graph": "hidden"
})

configure_column_visibility(ds.placeId, {
    "details": "hidden",
    "graph": "hidden"
})

configure_column_visibility(ds.price, {
    "details": "hidden",
    "graph": "hidden"
})

configure_column_visibility(ds.rating, {
    "details": "hidden",
    "graph": "hidden"
})

configure_column_visibility(ds.responseFromOwnerDate, {
    "details": "hidden",
    "graph": "hidden"
})

configure_column_visibility(ds.responseFromOwnerText, {
    "details": "hidden",
    "graph": "hidden"
})

configure_column_visibility(ds.reviewId, {
    "details": "hidden",
    "graph": "hidden"
})

configure_column_visibility(ds.reviewOrigin, {
    "details": "hidden",
    "graph": "hidden"
})

configure_column_visibility(ds.reviewUrl, {
    "details": "hidden",
    "graph": "hidden"
})

configure_column_visibility(ds.reviewerId, {
    "details": "hidden",
    "graph": "hidden"
})

configure_column_visibility(ds.reviewerUrl, {
    "details": "hidden",
    "graph": "hidden"
})

configure_column_visibility(ds.searchString, {
    "details": "hidden",
    "graph": "hidden"
})

configure_column_visibility(ds.temporarilyClosed, {
    "details": "hidden",
    "graph": "hidden"
})

configure_column_visibility(ds.cid, {
    "details": "hidden",
    "graph": "hidden"
})

configure_column_visibility(ds.city, {
    "details": "hidden",
    "graph": "hidden"
})

configure_column_visibility(ds.countryCode, {
    "details": "hidden",
    "graph": "hidden"
})

configure_column_visibility(ds.fid, {
    "details": "hidden",
    "graph": "hidden"
})

configure_column_visibility(ds.isAdvertisement, {
    "details": "hidden",
    "graph": "hidden"
})

configure_column_visibility(ds.permanentlyClosed, {
    "details": "hidden",
    "graph": "hidden"
})

configure_column_visibility(ds.postalCode, {
    "details": "hidden",
    "graph": "hidden"
})

configure_column_visibility(ds.reviewerPhotoUrl, {
    "details": "hidden",
    "graph": "hidden"
})

configure_column_visibility(ds.state, {
    "details": "hidden",
    "graph": "hidden"
})

configure_column_visibility(ds.street, {
    "details": "hidden",
    "graph": "hidden"
})

configure_column_visibility(ds.title, {
    "details": "hidden",
    "graph": "hidden"
})

configure_column_visibility(ds.url, {
    "details": "hidden",
    "graph": "hidden"
})

configure_column_visibility(ds.publishedAtDate, {
    "graph": "pinned"
})

configure_column_visibility(ds.text, {
    "graph": "pinned"
})

configure_columns_order(ds.text,
    ds.publishedAtDate,
    ds.stars,
    ds.isLocalGuide,
    ds.likesCount,
    ds.address,
    ds.textTranslated,
    ds.categoryName,
    ds.imageUrl,
    ds.location_lat,
    ds.location_lng,
    ds.name,
    ds.placeId,
    ds.price,
    ds.publishAt,
    ds.rating,
    ds.responseFromOwnerDate,
    ds.responseFromOwnerText,
    ds.reviewId,
    ds.reviewOrigin,
    ds.reviewUrl,
    ds.reviewerId,
    ds.reviewerNumberOfReviews,
    ds.reviewerUrl,
    ds.reviewsCount,
    ds.searchString,
    ds.temporarilyClosed,
    ds.cid,
    ds.city,
    ds.countryCode,
    ds.fid,
    ds.isAdvertisement,
    ds.neighborhood,
    ds.permanentlyClosed,
    ds.postalCode,
    ds.reviewerPhotoUrl,
    ds.state,
    ds.street)

configure_columns_order(ds.text,
    ds.publishedAtDate,
    ds.stars,
    ds.isLocalGuide,
    ds.likesCount,
    ds.address,
    ds.textTranslated,
    ds.categoryName,
    ds.imageUrl,
    ds.location_lat,
    ds.location_lng,
    ds.name,
    ds.placeId,
    ds.price,
    ds.publishAt,
    ds.rating,
    ds.responseFromOwnerDate,
    ds.responseFromOwnerText,
    ds.reviewId,
    ds.reviewOrigin,
    ds.reviewUrl,
    ds.reviewerId,
    ds.reviewerNumberOfReviews,
    ds.reviewerUrl,
    ds.reviewsCount,
    ds.searchString,
    ds.temporarilyClosed,
    ds.cid,
    ds.city,
    ds.countryCode,
    ds.fid,
    ds.isAdvertisement,
    ds.neighborhood,
    ds.permanentlyClosed,
    ds.postalCode,
    ds.reviewerPhotoUrl,
    ds.state,
    ds.street,
    {
        "for": "dataTable"
    })

create_project(ds)